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

42 votes372 views6 answers
Install beautifulsoup
SQL
0 vote325 views1 answer
Postgres change the name of schema
SQL
0 vote256 views1 answer
How to set field to null in sql
SQL
2 votes290 views1 answer
Enum in SQL Server
SQL
0 vote310 views1 answer
Suse status MySQL
SQL
0 vote252 views1 answer
Import csv to mysql
SQL
8 votes300 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote277 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
12 votes319 views2 answers
Insert multiple rows from another table sql
SQL
0 vote284 views1 answer
INSERT INTO table using OpenQuery
SQL