How can you move specified rows to the end when sorting in SQL in Oracle?

In Oracle, the ORDER BY clause can be used to sort the result set. If you want to place specific rows at the end, you can use a CASE statement for conditional sorting in the ORDER BY clause.

Here is an example: suppose there is a table called “employees” with a column named “employee_id,” and you want to move the row with employee_id 100 to the bottom.

SELECT * 
FROM employees
ORDER BY (CASE WHEN employee_id = 100 THEN 1 ELSE 0 END), employee_id;

This query will first sort based on the condition of the CASE statement, returning 1 if employee_id equals 100 and 0 otherwise. Then, it will sort by employee_id. This will effectively move the rows with an employee_id of 100 to the end.

Please note that if you want to put multiple specific rows at the end, you can add more WHEN conditions to achieve this.