Implement LESS THAN a certain id with ORDER BY

Question

Continue from my question before. here

After move some row to the top of all rows using ORDER BY

SELECT *
FROM   comments
ORDER  BY comment <> 'my comment', id;

How if i want the other comment start from example like less than id = 5?

                      id      comment
other comment         149    my comment
other comment         148    my comment
other comment         147    my comment
my comment       =>    4     other comment -- start from less than id = 5
other comment          3     other comment
my comment             2     other comment
my comment             1     other comment

Answer 1

Should translate to:

SELECT *
FROM   comments
WHERE (id < 5 or comment = 'my comment')
ORDER  BY comment <> 'my comment', id DESC;

fiddle

Related:

• Sort rows with given value before all other rows
• PostgreSQL: order by column, with specific NON-NULL value LAST