I have a table below:
Name idJohn 40Mary 50Peter 15John 40Peter 15John 40
How can I query to get who appeared most of the times in the table? (In the case, the answer is John.)
Try select count(*) from t1 group by name.
And…are you supposed to be doing this for your homework? 🙂