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

Add Own solution

Are there any code examples left?

Find Add Code snippet

New code examples in category SQL

SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
SQL 2022-03-27 19:20:41 sql is not null
SQL 2022-03-27 19:20:39 sql group by error
SQL 2022-03-27 18:35:10 replace null with 0 in sql
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
SQL 2022-03-27 16:45:07 kill a pid redshift
SQL 2022-03-27 16:00:09 joins in sql server

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

can we have a condition with order by in sql sql orderby clause sql order and where how to use where clause with order by in sql orderby sql with condition order by and where clause in sql server sql where condition ascending where with order by sql where condition with order by in sql querydsl or condition order query for order by clause with where clause in sql order by where clause in sql order by with when clause where condition and order by in sql asc SQL "ORDER BY IF" sql order by if condition in order by sql if clause in order by sql order by where clause order by clause in sql with condition sql order by if condition order by and where clause in sql order by in where condition condition order by sql order by with condition in sql how to check condition to order by in sql order by query with where condition sql order by with condition order by in specific condition sql order by and where in sql order by clause order by sql with where clause sql order by with where SQL if order by order by in sql with condition order by in sql with where condition how to order in sql when condition order by with where clause in sql where condition and order by in sql order by with where clause order by condition in sql sql order by without where clause what is the use of orderby in table ? sql order by where condition sql query with descending order with where condition where and order by clause in sql order by sql query example order in where sql The ORDER BY clause must be placed before the WHERE clause in a SQL statement. select from where oredre by order by and where clause together in sql how to write orderby and where clause in sql

sql order by where condition

Welcome Back!

Create a Free Account