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 vote361 views1 answer
Power bi find all ids not in other tables
SQL
0 vote345 views1 answer
How to check default value of column in sql server
SQL
0 vote363 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote384 views1 answer
Mariadb set vertical output format
SQL
1 vote396 views1 answer
Postgres see sequence current state
SQL
0 vote351 views1 answer
ORA-00942
SQL
1 vote354 views1 answer
Psql client write to bash variable
SQL
13 votes367 views2 answers
Sql online compiler
SQL
0 vote352 views1 answer
How to input data as id in database sql c#
SQL
0 vote402 views1 answer
SQL joins in python
SQL