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

7 votes220 views2 answers
Where keyword sql
SQL
0 vote233 views1 answer
Sql express database size limit
SQL
-1 vote193 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote221 views1 answer
Use mysql in java program
SQL
0 vote211 views1 answer
Sql server alter table column nullable
SQL
0 vote203 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
1 vote209 views1 answer
Sql where last 12 months
SQL
2 votes219 views1 answer
Mysql change data type of column
SQL
0 vote179 views1 answer
Get number of table colums in sql query
SQL
-1 vote211 views1 answer
How to create foreign key in sql server management studio
SQL