I have a table below:
Table
Name id
John 40
Mary 50
Peter 15
John 40
Peter 15
John 40
How can I query in SQL to get who appear most of the times in the table?
(in the case, the answer is John)
please help me¡Kthanks
My email address is
l.liou@student.unsw.edu.au
lunchih@hotmail.com
thanks a lot
primer in Oracle