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 vote210 views1 answer
Add 10 to all numbers in a column sql
SQL
5 votes152 views1 answer
Oracle sysdate
SQL
0 vote176 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote176 views1 answer
Get initial in sql
SQL
0 vote157 views1 answer
Mysql command prompt date insert format
SQL
21 votes124 views7 answers
Table drop if exist sql server
SQL
0 vote175 views1 answer
Java spring boot connect to sql server
SQL
14 votes166 views1 answer
Oracle alter table add column not null
SQL
0 vote163 views1 answer
Drop database using terminal postgres
SQL
0 vote120 views1 answer
Postgres delete where id in
SQL