SQl maximum occurance of a object

Question

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

SELECT Name, MAX([Used Food]) AS Max_Used_Food

FROM SomeTable

GROUP BY Name

-- Gianluca Sartori

amithpdn SSC Journeyman Points: 85 More actions · Answer 2

Thanks for the quick reply. if I WANT THE NUMBER OF OCCURANCES AS WELL WHAT I SHOULD DO

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 3

SELECT Name, MAX([Used Food]),COUNT(Name) AS Max_Used_Food

FROM SomeTable

GROUP BY Name

Try this...

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 4

SELECT Name, MAX([Used Food]) AS Max_Used_Food

,COUNT(Name) AS Count_Food

FROM SomeTable

GROUP BY Name

I was little fast for the column header...try this.