Sql

Search

sql order by except one row

SELECT name
FROM categories
ORDER
    BY CASE WHEN name = 'Other'
            THEN 1 -- last
            ELSE 0 -- first
        END ASC
     , name ASC

Comment

PREVIOUS	NEXT

Code Example
Sql :: how to avoid duplicate records in sqlite
Sql :: rownum in sql
Sql :: docker use mysql
Sql :: drop databse
Sql :: reindex mssql table
Sql :: linux upload database to mysql
Sql :: oracle logfile switch
Sql :: truncate table sql server foreign key
Sql :: import sql file to mysql db using shell commands
Sql :: what is subquery in sql
Sql :: drop procedure postgres
Sql :: mysql loop through databases and execute query
Sql :: mysql select field if condition
Sql :: postgres insert new row advance count
Sql :: mysql undo delete
Sql :: create and attach user to a postgresql database
Sql :: equi joins in oracle
Sql :: sql transfer table in other
Sql :: mysql date comparison with formatting
Sql :: sql change primary key to composite key
Sql :: fatal error uncaught mysqli_sql_exception
Sql :: sql update subtract value
Sql :: oracle procedure teamplate
Sql :: delete join sql server
Sql :: quit mysql
Sql :: mysql create trigger
Sql :: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client . Can not run php artisan migrate
Sql :: apex run 404
Sql :: SQLite (sqlite 3.27.2) sample
Sql :: how to set up an anonymous function to variable in swift

Search

SQL

sql order by except one row

ADD CONTENT