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 vote260 views1 answer
Sum sqlserver
SQL
0 vote271 views1 answer
Oracle character index
SQL
1 vote296 views3 answers
Rows, INSERT INTO
SQL
0 vote300 views1 answer
Sql select sum group by id laravel join
SQL
0 vote276 views1 answer
Postgresql delete multiple rows
SQL
0 vote238 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote243 views1 answer
Get only first row mysql
SQL
10 votes273 views1 answer
Create table oracle
SQL
4 votes310 views1 answer
What are the data types
SQL
0 vote272 views1 answer
How to get employee having maximum experience in mysql
SQL