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

1 vote224 views1 answer
Oracle boolean to varchar
SQL
0 vote227 views1 answer
Jooq finding lastest value in table
SQL
1 vote284 views1 answer
Sql select whole row max column
SQL
3 votes286 views1 answer
Start mysql server by terminal in linux
SQL
0 vote288 views1 answer
Call object contructor and call methods of object
SQL
0 vote268 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote255 views1 answer
Mysql group by derived column
SQL
5 votes301 views2 answers
Add days in oracle sql
SQL
1 vote253 views1 answer
Stop mysql server mac
SQL
1 vote262 views1 answer
How to make a select in sql
SQL