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 vote116 views1 answer
Oracle list index on table
SQL
1 vote136 views1 answer
Sql random sampling per group
SQL
0 vote129 views1 answer
Sp in sql server
SQL
2 votes118 views1 answer
Alter table add multiple columns postgresql
SQL
9 votes154 views6 answers
Replace sql
SQL
0 vote194 views1 answer
Mysql delete entire row on condition
SQL
4 votes115 views1 answer
Postgresql show current database
SQL
0 vote160 views1 answer
Sql query to select even numbers
SQL
4 votes127 views2 answers
How to insert ip address in mysql using php
SQL
0 vote147 views1 answer
Mysql grant user wildcard database
SQL