The following example substitutes the integer 3 for yrs_exp in the ORDER BY clause. The 3 refers to the left-to-right sequential numeric position of yrs_exp in the select expression list.
SELECT name, jobtitle, yrs_exp FROM employee ORDER BY 3;
The following example substitutes the integer 3 for yrs_exp in the ORDER BY clause. The 3 refers to the left-to-right sequential numeric position of yrs_exp in the select expression list.
SELECT name, jobtitle, yrs_exp FROM employee ORDER BY 3;