I am trying to order by lowest however this sql term below order's by highest number
SELECT * FROM questions ORDER BY question_ref DESC LIMIT 1;
Any help would be appreciated
I am trying to order by lowest however this sql term below order's by highest number
SELECT * FROM questions ORDER BY question_ref DESC LIMIT 1;
Any help would be appreciated
Use ASC
instead of DESC
:
SELECT * FROM questions ORDER BY question_ref ASC LIMIT 1;