Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Postgresql Special Order BY

Tags:

postgresql

sql-order-by

I need to use an ORDER BY on a table but keep some special rows on top. The rows that have name='developer' for example.

like image 428
johnlemon Avatar asked Aug 07 '26 23:08

johnlemon

1 Answers

ORDER BY CASE WHEN name = 'developer' THEN '0' ELSE name END
like image 199
mechanical_meat Avatar answered Aug 11 '26 09:08

mechanical_meat
Sign in to Comment

Related questions

String primary key comprised of date and auto incrementing integer
POSTGRES_PASSWORD_FILE no working on docker compose
How to export large data from Postgres to S3 using Cloud composer?
Count number of points (from two datasets) contained by neighbourhood polygons using PostGIS
NestJS TypeORM syntax error in migration file
Using National ID as Primary Key
how to use group by in postgresql
Prevent usage of index for a particular query in Postgres
JOOQ Doesn't Generate
Create function to create table Postgresql
pg_dump server and pg_dump version mismatch in docker
postgres full text search add period to parser
select all except for a specific column
Is it possible to export firebase cloud firestore data to a postgresql?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!