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 vote234 views1 answer
Jpa generationtype sequence mysql
SQL
5 votes204 views1 answer
Oracle sysdate - 1 month
SQL
2 votes207 views1 answer
Postgresql update sequence next value
SQL
0 vote210 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote190 views1 answer
Alter table myisam to innodb
SQL
16 votes199 views4 answers
Find duplicates mysql
SQL
9 votes193 views2 answers
Get first 3 letters in sql
SQL
0 vote214 views1 answer
Pl sql disable trigger
SQL
6 votes179 views1 answer
Oracle trigger after connect
SQL
1 vote187 views1 answer
Scaffold mysql database
SQL