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

0 vote253 views1 answer
How to pass list as parameter in SQL query
SQL
2 votes214 views3 answers
Sql interview query questions
SQL
0 vote236 views1 answer
Error code 1451 sql
SQL
3 votes223 views2 answers
Truncate table
SQL
-1 vote193 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
7 votes195 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
3 votes231 views1 answer
Laravel paginate raw sql
SQL
2 votes211 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
3 votes186 views2 answers
Oracle sql select all days between two dates except weekends
SQL
1 vote226 views1 answer
Add sequence postgres
SQL