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

8 votes120 views1 answer
Sql limit results returned
SQL
3 votes133 views2 answers
How to list columns for particular tables in postgresql
SQL
1 vote135 views1 answer
Sqlite3 read only
SQL
0 vote128 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
4 votes138 views1 answer
List tables sqlite
SQL
2 votes119 views1 answer
Mysql virtual column
SQL
0 vote117 views1 answer
Drop tables from local database postgres pgadmin
SQL
1 vote115 views3 answers
Sql server get week dates from week number
SQL
0 vote136 views1 answer
Create query in where clasue
SQL
1 vote87 views1 answer
Import in mysql without a software
SQL