Create view in SQL

create view vw_active_employee

as

select * from employee

where status = 'Active'

after creating the view, view can be used as a table to see active employee.

e.g. select * from vw_active_employee

Basically we save sql as a database object, so that we can use that in future as a virtual table.