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 vote199 views2 answers
Php convert dbf to mysql
SQL
1 vote161 views1 answer
How to update date add hours in postgresql
SQL
0 vote197 views1 answer
Mysql get hour from datetime
SQL
0 vote174 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote206 views1 answer
How to open mysql in docker
SQL
0 vote177 views1 answer
Copied text from internet not inserting in mysql
SQL
1 vote166 views1 answer
Get last week data in mysql
SQL
0 vote218 views1 answer
Selecting from a view SQL
SQL
0 vote155 views1 answer
Sql view index
SQL
1 vote193 views1 answer
Limit offset order by mysql
SQL