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 vote184 views1 answer
Mysql date minus 1 day
SQL
4 votes187 views2 answers
Sql table
SQL
5 votes211 views1 answer
Oracle list functions
SQL
0 vote193 views1 answer
Mssql current date
SQL
5 votes200 views2 answers
Ranking functions in sql
SQL
3 votes202 views1 answer
Select sequence oracle
SQL
1 vote156 views1 answer
Ms sql how to see active job current run time
SQL
3 votes186 views1 answer
Oracle rollback
SQL
7 votes193 views2 answers
Create index mysql
SQL
6 votes180 views2 answers
How to copy data in sql
SQL