Restriction in a view definition

The ORDER BY clause is not allowed in a view definition.

Example views

This view exposes only some of the columns of emp table:

CREATE VIEW emp_info AS SELECT empno, ename FROM emp;

This view exposes derived columns:

CREATE VIEW emp_payroll(empno, total_pay) AS SELECT empno, sal+bonus FROM emp;

CREATE VIEW dept_info(deptno, emp_count) AS SELECT deptno, COUNT(*)

`FROM emp GROUP BY deptno;``

This view exposes a restricted result set of the base table:

CREATE VIEW emp_high_pay(empno, sal) AS SELECT emp, sal FROM emp

WHERE sal > 100000

This view hides data complexity by exposing the result of a JOIN query:

CREATE VIEW emp_full_info AS (e.empno, d.deptno, d.deptname FROM emp e, dept d WHERE e.deptno = d.deptno;