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 vote167 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote200 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
2 votes193 views1 answer
Sql percentage with % rounded down
SQL
1 vote174 views1 answer
Too many connections mysql
SQL
0 vote167 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote190 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote202 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote168 views1 answer
Create table if not exist with exceptions
SQL
0 vote172 views1 answer
10000000000000000000 am to meters
SQL
0 vote166 views1 answer
Power query case when
SQL