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 vote175 views1 answer
Mysql view current queries
SQL
7 votes153 views2 answers
MySQL IF without else
SQL
0 vote142 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote153 views1 answer
Supprimer les valeur d'une table mysql
SQL
12 votes132 views5 answers
Sql merge
SQL
0 vote139 views1 answer
How to get data between a last week in mysql
SQL
56 votes399 views5 answers
Psql create user
SQL
0 vote154 views2 answers
How to use aggregate functions in sql
SQL
16 votes182 views3 answers
Order by sql query
SQL
12 votes154 views1 answer
Docker run mysql image
SQL