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

10 votes347 views2 answers
SQL rounding numbers
SQL
1 vote324 views1 answer
Oracle duration between timestamps
SQL
0 vote311 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote357 views1 answer
Move table to a different schema
SQL
-1 vote351 views1 answer
Pl/sql how to delete a trigger
SQL
1 vote340 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote359 views2 answers
Coursera spark sql max count
SQL
4 votes369 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
18 votes318 views6 answers
Mysql create table
SQL
4 votes305 views1 answer
Fetch first 10 rows in oracle sql developer
SQL