SQL - Structured Query Language

Use Built-in Function - VIEW

The following example defined with built-in function. When use built-in function, the derived column must include a column name in the CREATE VIEW statement. The following query is used to display department wise max salary employee information.

-- Example 61 --


USE EBusiness



CREATE VIEW DeptMaxSalary (Emp_Name, Max_Salary)


SELECT Dept_Code, MAX(Salary) FROM EMP

GROUP BY Dept_Code



SELECT * FROM DeptMaxSalary

Query Output Screen

* * * * *

Email Your Comment To AUTHOR