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

2 votes249 views1 answer
Query to find table size in oracle 12c
SQL
1 vote258 views1 answer
Postgres install unaccent extension
SQL
0 vote257 views1 answer
Oracle current timestamp
SQL
1 vote255 views1 answer
Mysql change root mysql_native_password
SQL
0 vote259 views1 answer
Sql server remove primary key without dropping table
SQL
0 vote266 views1 answer
Get who is hired in month in sql
SQL
0 vote251 views1 answer
Turnicate in mysql
SQL
0 vote310 views1 answer
Stop and start mysql
SQL
0 vote254 views1 answer
Grouping by email domain mysql
SQL
2 votes252 views1 answer
Apex date today add days
SQL