devxlogo

Table Query

Table Query

Question:
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.)

Answer:
Try select count(*) from t1 group by name.

And…are you supposed to be doing this for your homework? 🙂

devx-admin

Share the Post: