rgb192
asked on
mysql one result
using mysql
select column from table order by column desc
I only want the fifth result
select column from table order by column desc
I only want the fifth result
ASKER
I have to do a similar task with another database (mysql)
The first sql server result worked for me the best
The first sql server result worked for me the best
ASKER
select column from table order by column desc limit 0,4
ASKER
does sql server also have limit function
because mysql does not have top or cte
because mysql does not have top or cte
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Well explained
thank you
thank you
Please explain why you've repeated this question, which you've accepted without responding to any other expert comments:
https://www.experts-exchange.com/questions/27831446/only-want-one-result.html