PostgreSQL row sort with NULL values and empty string at last

Question

I have used the following SQL, and it's working fine, but I need to sort empty strings also. Please give me guidance on this.

SELECT id, first_name, last_name 
FROM users
ORDER BY first_name DESC NULLS LAST
limit 10;

mu is too short · Accepted Answer · 2011-07-22 15:53:27Z

47

ORDER BY NULLIF(first_name, '') DESC NULLS LAST

mu is too short

436k71 gold badges863 silver badges822 bronze badges

answered Jul 22, 2011 at 9:40

kan

29.2k7 gold badges75 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Piyush Chaudhary · Accepted Answer · 2021-08-05 17:34:55Z

1

ORDER BY IF( first_name = '' OR first_name IS NULL,1,0), first_name;

answered Aug 5, 2021 at 17:34

Piyush Chaudhary

3233 silver badges14 bronze badges