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 vote105 views1 answer
ALV GRID events
SQL
0 vote162 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
0 vote105 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
2 votes107 views1 answer
How to find constraints on a table in oracle
SQL
3 votes116 views1 answer
Postgres add not null to existing column
SQL
6 votes93 views2 answers
Find mysql version linux
SQL
0 vote122 views1 answer
Running percentage of total postgres
SQL
0 vote100 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
1 vote102 views2 answers
Sql where keyword
SQL
16 votes101 views2 answers
Sql exists
SQL