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 vote352 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
6 votes170 views2 answers
Mysql set primary key
SQL
3 votes173 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
1 vote184 views1 answer
Mysql print variable
SQL
9 votes203 views3 answers
Sql delete where in
SQL
3 votes170 views1 answer
Force using index oracle
SQL
2 votes175 views1 answer
Sql server case sensitive search
SQL
11 votes185 views2 answers
Having clause in sql
SQL
6 votes171 views1 answer
Identify primary key in oracle table
SQL
2 votes167 views2 answers
Mamp connect mysql terminal
SQL