Nested SQL query not working

Question

I am trying to run the following sql query:

select *
from fblikes
order by likes desc (select * from fblikes order by id asc limit 0,4)

it gives the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select * from fblikes order by id asc limit 0,4) LIMIT 0, 30' at line 1

what i want to achieve is that the query should select first 5 entries by 'id' (ascending) and out of those 5 it should order them by 'likes' (descending).

I am poor at nested queries. Any Help?

@fthella thanks for the edit. I'll take care to properly edit the question from now on — Arihant
– Arihant, Commented Feb 17, 2013 at 11:14

Mahmoud Gamal · Accepted Answer · 2013-02-17 11:09:27Z

2

select * 
from 
(
   select * 
   from fblikes 
   order by id asc 
   limit 0,4
) AS Sub
order by likes desc ;

answered Feb 17, 2013 at 11:09

Mahmoud Gamal

80.2k18 gold badges143 silver badges168 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Arihant Over a year ago

Thanks that worked! Will accept this as the correct answer once the timeoff ends! Cheers!

Collectives™ on Stack Overflow

Nested SQL query not working

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related