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