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

10 votes115 views1 answer
Oracle dependencies table
SQL
1 vote117 views1 answer
Check if mysql is installed
SQL
0 vote123 views1 answer
Mysql could not fetch tables
SQL
0 vote113 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote105 views1 answer
Wp_query raw sql
SQL
3 votes108 views1 answer
Stpop start psql server
SQL
0 vote125 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote116 views1 answer
Cast float mysql
SQL
1 vote113 views2 answers
Sql left characters
SQL
0 vote109 views1 answer
Mariadb cast null to 0
SQL