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 vote271 views1 answer
View psql output in horizontal scrolling
SQL
2 votes283 views2 answers
Sqlalchemy return id after insert
SQL
0 vote250 views2 answers
Change database postgres
SQL
0 vote269 views1 answer
Distinct data types in a table sql query
SQL
1 vote257 views1 answer
Oracle list constraints
SQL
0 vote271 views1 answer
Oracle show grants on table
SQL
1 vote262 views1 answer
Oracle rolling back
SQL
2 votes278 views2 answers
Mysql write into table
SQL
2 votes279 views1 answer
Sql string_agg
SQL
0 vote264 views1 answer
Creation d'un trigger sql
SQL