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

-1 vote408 views4 answers
Full outer join in sql
SQL
0 vote342 views1 answer
Create table if not exist with exceptions
SQL
1 vote356 views1 answer
How to make a select in sql
SQL
1 vote399 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote366 views1 answer
Sqlite update only if greater
SQL
19 votes378 views3 answers
How to change column type psql
SQL
3 votes355 views1 answer
Mssql remove column
SQL
0 vote352 views1 answer
Drop a field in psql django
SQL
0 vote344 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote378 views1 answer
Sql string contains case sensitive
SQL