Return specific Row first and then other Row follow

Question

I want to print the trending row first and then New and then all other row from the table "employee".

Also i want limit the number of row and in descending order

I was trying this

SELECT * FROM (SELECT * FROM employee LIMIT 7) sub ORDER BY id DESC

Expected Result

Based on the preponderance of tags, I removed mysql. – Gordon Linoff Jun 01 '20 at 11:07 — Gordon Linoff, Jun 01 '20 at 11:07

score 2 · Accepted Answer · answered Jun 01 '20 at 09:21

2

You may try ordering with a CASE expression:

SELECT id, Name, Status
FROM employee
ORDER BY
    CASE Status WHEN 'Trending' THEN 1
                WHEN 'NEW' THEN 2
                ELSE 3 END,
    id DESC
LIMIT 7;

answered Jun 01 '20 at 09:21

Tim Biegeleisen

502,043
27
286
360

It fetching all the row look like Limit function is not working and Yes condition work fine – Rohit Kumar Sehrawat Jun 01 '20 at 11:56
`LIMIT 7` can only return 7 or fewer rows, leading me to suggest that you are not actually running the query in my answer. – Tim Biegeleisen Jun 01 '20 at 12:02

Return specific Row first and then other Row follow

1 Answers1