I have a table this way:
And so on, (of course with more then two names)
I need to get a list of the 500 names that are most used in that column. I have no idea how to do this, please help.
| Code: |
|
+=========+ + name +=========+ | john +---------+ | joe +---------+ | john +---------+ | john +---------+ | joe +---------+ | john +---------+ |
And so on, (of course with more then two names)
I need to get a list of the 500 names that are most used in that column. I have no idea how to do this, please help.
I get so annoyed if people put select collum rather than SELECT `collum`
Well, what a reason to hate me. SQL standard doesn't enforce using any quotes around column name. It is mysql documents which contain these quotes. Refer to any other database (like oracle or db2 or sybase) docs. You will never find these back-ticks.
