SQL Writing Queries 20/23


#1

I'm having trouble figuring out how to get the first 10 rows and reverse alphabetically order them. I tried to use LIMIT 10 to get the first 10 rows:

SELECT name FROM movies ORDER BY name DESC LIMIT 10;

but I'm restricted to ordering before limiting, which gives me the last 10 movies in the database.

I've attempted to put LIMIT before ORDER BY, tried SELECT TOP and tried WHERE ROWNUM <= 10; All 3 of these will result in the spinner going non stop.

Any suggestions?


#2

Have you tried to include:

 WHERE id <= 10

#3

I just tried it now and.... IT WORKS! THANK YOU!!!