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 vote193 views2 answers
Update all columns in one update
SQL
1 vote199 views2 answers
Oracle replace
SQL
3 votes194 views1 answer
Sql insert inserted id
SQL
1 vote196 views2 answers
Update with inner join sql server
SQL
5 votes780 views1 answer
Oracle ora-00054 find
SQL
5 votes186 views1 answer
Postgresql functions
SQL
0 vote239 views1 answer
Mariadb change column type
SQL
1 vote195 views2 answers
Sql server backup table
SQL
0 vote193 views1 answer
Mysql backup certain tables workbench
SQL
0 vote200 views1 answer
Geopoint from json mysql function
SQL