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

7 votes388 views2 answers
How to create index mysql
SQL
1 vote330 views1 answer
Sqlite3 read only
SQL
1 vote351 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
10 votes330 views2 answers
Sql rtrim
SQL
0 vote348 views1 answer
Mysql range of dates overlap
SQL
0 vote335 views1 answer
Mariadb hours between two dates
SQL
1 vote404 views1 answer
Oracle select first row order by
SQL
1 vote387 views1 answer
UseSqlServer no definition
SQL
5 votes338 views1 answer
Commentaire table oracle
SQL
5 votes343 views4 answers
Rollback to in sql
SQL