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 vote301 views1 answer
How to stop all connections to a psql 12 database?
SQL
1 vote315 views1 answer
How to see which columns are indexxed mysql
SQL
1 vote319 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
16 votes281 views2 answers
Gremove folder from git
SQL
1 vote311 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote303 views1 answer
Add computed column to table sql server
SQL
0 vote320 views1 answer
Mssql dockere
SQL
0 vote287 views1 answer
Add plugins to mysql workbench
SQL
13 votes330 views3 answers
List all the tables in sql
SQL
0 vote309 views1 answer
Interview experience as a call?
SQL