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

6 votes113 views3 answers
Mysql change auto_increment start value
SQL
0 vote117 views1 answer
Oracle job session
SQL
1 vote109 views1 answer
Oracle start job
SQL
0 vote115 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
0 vote112 views1 answer
Mysql two joins
SQL
0 vote69 views1 answer
Update row in sqlite python
SQL
0 vote118 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
0 vote140 views1 answer
Mysql get nth highest
SQL
4 votes126 views3 answers
Postgres set default value
SQL
0 vote126 views1 answer
Get last three characters in mysql column
SQL