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 vote154 views1 answer
Psql no such file or directory
SQL
2 votes135 views1 answer
Pandas to sql index
SQL
0 vote92 views0 answer
SQL
0 vote202 views1 answer
Trigger
SQL
1 vote141 views3 answers
Psql fatal database does not exist
SQL
1 vote131 views1 answer
Create sample data postgresql
SQL
0 vote128 views1 answer
Mysql money value
SQL
1 vote144 views1 answer
Name of today sql
SQL
1 vote135 views1 answer
Create another table from existing table sql oracle
SQL
0 vote137 views1 answer
MySQL error code 2068
SQL