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 vote182 views10 answers
Stack overflow
SQL
0 vote176 views1 answer
Get records in sql according to month name and count
SQL
0 vote238 views1 answer
Alternative for LIMIT sql
SQL
0 vote185 views1 answer
Primary key multiple colums
SQL
0 vote139 views1 answer
Oracle list all stored procedures
SQL
0 vote183 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
-1 vote216 views2 answers
Sql truncate number
SQL
2 votes252 views1 answer
Oracle block
SQL
0 vote180 views3 answers
Joins and views sql
SQL
0 vote177 views1 answer
How to start my sql server on mac
SQL