Sql order by where condition

SELECT ProcductCode AS Id, ProductPrice AS Price
FROM Products WITH (NOLOCK)
WHERE ProductCode IN ('efg', 'abc', 'xyz')
ORDER BY (CASE WHEN ProductCode = 'efg' THEN 1
               WHEN ProductCode = 'abc' THEN 2
               WHEN ProductCode = 'xyz' THEN 3
               ELSE 4  -- in case you change the `where`, put them last
          END);

Source: stackoverflow.com

Similar codes

24 votes132 views5 answers
Sql reset auto increment
SQL
0 vote134 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
3 votes170 views2 answers
Brew restart mysql
SQL
9 votes129 views3 answers
Mysql show table column full description
SQL
0 vote130 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
1 vote138 views1 answer
Oracle sql average
SQL
0 vote131 views1 answer
How to see password mysql vestacp
SQL
0 vote129 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
4 votes146 views1 answer
Sql quote in string
SQL
0 vote141 views1 answer
How to select even id in sql
SQL