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 votes275 views1 answer
Alter tablespace add datafile
SQL
0 vote279 views2 answers
How to save result of sqlite query in a table
SQL
0 vote277 views1 answer
Sql server whoami
SQL
1 vote319 views1 answer
Insert many to many sql
SQL
1 vote297 views1 answer
Mysql decimal allow negative values?
SQL
0 vote274 views1 answer
Truncate table sql server foreign key
SQL
6 votes284 views4 answers
How to remove unique key in mysql
SQL
5 votes285 views1 answer
How to check port number for postgresql
SQL
-1 vote308 views1 answer
Minus vs except in sql
SQL
0 vote327 views1 answer
Delete hangfire retries list
SQL