Sql order by where condition

This article is tagged with: Sql order by where condition and mysql

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);

This article is tagged with: Sql order by where condition and mysql