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

10 votes319 views2 answers
Sql where clause multiple values
SQL
3 votes339 views1 answer
Oracle function
SQL
0 vote331 views1 answer
How to to get current date and time in sql
SQL
17 votes318 views2 answers
How to assign date field for table in mysql
SQL
0 vote351 views1 answer
To Create directory
SQL
10 votes362 views2 answers
Rtrim sql
SQL
0 vote335 views3 answers
Convert sql query to python pandas
SQL
3 votes368 views1 answer
Increment integer in table sql
SQL
27 votes342 views4 answers
Get all tables with column name sql
SQL
3 votes356 views1 answer
Force using index oracle
SQL