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 vote339 views1 answer
Sqlite3 update select
SQL
2 votes387 views1 answer
Create delete procedure mysql
SQL
12 votes328 views6 answers
Between in sql
SQL
0 vote336 views1 answer
Mariadb alter table add column if not exists example
SQL
1 vote335 views2 answers
Mssql show database size
SQL
4 votes305 views1 answer
Update table from another table oracle
SQL
4 votes295 views1 answer
Mac install mysql
SQL
0 vote343 views1 answer
Min mysql
SQL
1 vote326 views1 answer
Count mysql server db tables
SQL
15 votes318 views2 answers
Install mysql 8 ubuntu 18.04
SQL