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

4 votes301 views1 answer
Conda install sqlalchemy
SQL
0 vote292 views1 answer
Sql composite key
SQL
1 vote308 views1 answer
T-sql find object by name
SQL
0 vote273 views1 answer
Nueva tabla mysql
SQL
1 vote291 views3 answers
How to truncate table with foreign key constraint
SQL
3 votes270 views1 answer
Sql select all
SQL
3 votes271 views1 answer
Sql datetime as date
SQL
0 vote292 views1 answer
Select into table variable
SQL
0 vote286 views1 answer
Plsql check for string in numeric
SQL
1 vote298 views1 answer
Sql headers delphi
SQL