I need a quick answer, please!

[littlenicky]

Let's say I have in my database teachers, each one has one subject, and I want to find the most common subject... How do I do this with SQL?

SELECT MAX(*)
FROM Teachers
GROUP BY Subject

??????

 

[dcx693]

Try something like this:
SELECT TOP 1 tblTeachers.Subject, Count(tblTeachers.Teacher) AS [Number]
FROM tblTeachers
GROUP BY tblTeachers.Subject
ORDER BY Count(tblTeachers.Teacher) DESC;

The TOP 1 part of the query will only show you the first item in the query results. Given that the results are sorted in descending order, it will give you the highest subject with the highest number of teachers.

 

[littlenicky]

Thanks for help!
I actually wanted ONLY the most common subject, but I see, I had to use COUNT()...