I have a table mstenquiries
It contains city,course,feeddate
i want to find the feeddate having highest no. of enquiries.
select top 1 Convert(varchar,feeddate,106),count(*) from cuaf.dbo.mstcuaf where sname not like 'Test%' and course<>'' group by Convert(varchar,feeddate,106) order by 2 desc
This result will give date and highest count
Now i want the course on this day which was having the highest enquiries.
How to find that/