2.06 sort by key of data item

Problem: You want to sort by some conditional logic. For example, if the job is "salesman", Sort by comm.

Solution: Use a CASE expression in an ORDER BY clause

Select Ename,sal,job,comm from emp
Order BY case-job = ' salesman ' then comm else Sal End

Discuss:
You can use case expressions to dynamically change how the results are sorted. The value passed to order by is similar to this:

Select Ename,sal,job,comm,
case If job = ' salesman ' then comm else Sal End as ordered
From EMP
ORDER BY 5

2.06 sort by key of data item