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 vote168 views2 answers
Drop tables from local table database postgres
SQL
1 vote159 views1 answer
Mysql return if it contains
SQL
0 vote169 views1 answer
Sql date time query find
SQL
1 vote147 views1 answer
Postgres get timestamp
SQL
0 vote143 views2 answers
Check mysql timezone
SQL
1 vote140 views1 answer
Oracle db create new schema
SQL
0 vote152 views1 answer
Ver usuarios mysql
SQL
13 votes140 views6 answers
Current date sql
SQL
16 votes164 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
7 votes150 views1 answer
Query postgres delete duplicates
SQL