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 vote237 views1 answer
Drush run sql select
SQL
0 vote240 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote225 views1 answer
Mysql installer no packages found
SQL
0 vote223 views6 answers
Unique key in sql
SQL
1 vote238 views1 answer
How to change owner in postgres
SQL
0 vote256 views1 answer
How to find sql server installation folder
SQL
7 votes239 views3 answers
Select latest entry in sql table
SQL
0 vote233 views1 answer
Get id if is not equal in certain table
SQL
6 votes288 views2 answers
How to get last element sql
SQL
2 votes244 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL