You can create a view by saying:
CREATE VIEW firstview as
select distinct empno from empcourse
This view can be accessed by
SELECT * from firstview
It continues to exist for all questions in this tutorial section. To get rid of it use "drop view firstview".
Create a view "secondview" which shows all employees who have an empno less than 5. In order to get a mark for this you must finish the queries with "select * from secondview".
|