I have a table having a time column in the format: 2022-09-13 07:54:34 So, I am trying to find the frequency of a column(test_language) according to this timestamp column. For example: if test_lang has occured 5 times for a given timestamp it should show the output that way.
Write now I'm using this query:
Select test_lang,count(test_lang) as Freq , time from testtable
where date='2022-09-13' group by test_lang,time order by Freq desc
This query is giving me Freq in desc order as I want but not sure the time column it is showing is it for that particular time this has occured that many times or not