Question: You have a SQL database that has the name of the countries and their population. You would like to ONLY get the name of the

You have a SQL database that has the name of the countries and their population. You would like to ONLY get the name of the top 3 most populated countries. Which query will do it for you?

a) SELECT name FROM TABLE ORDER BY population LIMIT 3

b) SELECT countries FROM TABLE ORDER BY name LIMIT 3

c) SELECT ONLY TOP 3 name from TABLE ORDER BY population

d) SELECT ONLY TOP 3 population from TABLE ORDER BY name

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!