Home > Software engineering >  how to create a view/table from a single column
how to create a view/table from a single column

Time:02-12

enter image description here

so i have the following table and want to create a query that will output the days it was most requested. for example on 01/02/2000 there was 3 requests in total, on 02/02/2000 there was 2 request in total, on 03/03/2000 there was 6 request in total and on 04/02/2000 there was 4 request in total. so basically i want to output this in table is that possible or will it be easier to just create another table with all this info and make dates a foreign key?

CodePudding user response:

use group by count like this

select Date,Count(Date) as Total from Table Group by Date
  • Related