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 vote227 views1 answer
Mysql last friday of current month
SQL
-2 votes203 views1 answer
How to open database
SQL
28 votes226 views6 answers
Mysql change user password
SQL
0 vote238 views2 answers
Amazon linux postgresql client
SQL
0 vote215 views7 answers
Les jointures sql server
SQL
0 vote232 views2 answers
Connect to mysql server mac terminal
SQL
2 votes220 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote223 views1 answer
Open postgresql.conf in centos
SQL
0 vote246 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
1 vote206 views2 answers
How to check username in mysql command line
SQL