How to Create a View

Any view has an associated select to obtain the view data, then in order to create a view you need to use an SQL statement defining the view name and the view select, like the following:

create view employees_making_more_than_100k as
select emp_id, first_name, last_name
from   employee
where  salary > 100000.00;

IN THIS PAGE