Identify the columns in the ORDER BY clause by the ordinal position of the column in the SELECT list
1> CREATE TABLE employee (emp_no INTEGER NOT NULL,
2> emp_fname CHAR(20) NOT NULL,
3> emp_lname CHAR(20) NOT NULL,
4> dept_no CHAR(4) NULL)
5> GO
1> insert into employee values(1, 'Matthew', 'Smith', 'd3')
2> insert into employee values(2, 'Ann', 'Jones', 'd3')
3> insert into employee values(3, 'John', 'Barrimore','d1')
4> insert into employee values(4, 'James', 'James', 'd2')
5> insert into employee values(5, 'Elsa', 'Bertoni', 'd2')
6> insert into employee values(6, 'Elke', 'Hansel', 'd2')
7> insert into employee values(7, 'Sybill', 'Moser', 'd1')
8> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
1> select * from employee
2> GO
emp_no emp_fname emp_lname dept_no
----------- -------------------- -------------------- -------
1 Matthew Smith d3
2 Ann Jones d3
3 John Barrimore d1
4 James James d2
5 Elsa Bertoni d2
6 Elke Hansel d2
7 Sybill Moser d1
(7 rows affected)
1> -- Identify the columns in the ORDER BY clause by the ordinal position of
the column in the SELECT list.
2>
3> SELECT emp_fname, emp_lname, dept_no FROM employee WHERE emp_no < 20000
4> ORDER BY 2, 1
5> GO
emp_fname emp_lname dept_no
-------------------- -------------------- -------
John Barrimore d1
Elsa Bertoni d2
Elke Hansel d2
James James d2
Ann Jones d3
Sybill Moser d1
Matthew Smith d3
(7 rows affected)
1> drop table employee
2> GO
1>
Related examples in the same category