Question 114358 in PostgreSQL Question posted in
The official documentation can be found here.

How to make order by specific value in PostgreSQL?

I wanna select data from table with ordering where first I’ll get values with specific value.

I tried this but it didn’t work:

SELECT name FROM test ORDER BY id ='d189463e-52dc-40e5-adf7-eddce74cf05e';
Tags:

2

Answers


  1. 0

    use a case expression This allows you to define whatever "ordering" you want for the IDs

    SELECT name 
FROM test 
ORDER BY CASE WHEN ID = 'd189463e-52dc-40e5-adf7-eddce74cf05e' THEN 1 
              WHEN ID = ... ELSE ... END;
    Login or Signup to reply.
  2. 0

    I would write

    ORDER BY id <> 'd189463e-52dc-40e5-adf7-eddce74cf05e'

    or

    ORDER BY id = 'd189463e-52dc-40e5-adf7-eddce74cf05e' DESC

    because FALSE < TRUE.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search