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 vote130 views1 answer
Mysql create pool
SQL
3 votes167 views2 answers
Brew restart mysql
SQL
0 vote126 views2 answers
Mysql update two tables at once
SQL
1 vote133 views2 answers
Logical operators in sql
SQL
0 vote169 views1 answer
Sql commands in android
SQL
61 votes309 views6 answers
Mysql add column
SQL
0 vote126 views1 answer
Sql server set complex constraints
SQL
1 vote146 views1 answer
Mysql find tables with column name
SQL
0 vote129 views1 answer
T-sql update table variale
SQL
5 votes144 views4 answers
Start postgres server
SQL