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 vote124 views3 answers
Constraint sql
SQL
0 vote91 views1 answer
<script>alert
SQL
1 vote93 views1 answer
Data type and their numeric form
SQL
2 votes121 views3 answers
Sql interview query questions
SQL
0 vote130 views1 answer
Mysql where sum > 0
SQL
0 vote100 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote107 views1 answer
Mysql root permission denied lost
SQL
0 vote135 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
0 vote112 views1 answer
Mssql dockere
SQL
15 votes109 views5 answers
Select all tables sql
SQL