16. Views.sql

use ecom;
-- VIEWS

-- Whenever we have to dedup our data, we have to run the query we worte before all the time.
-- Is there any way that we can store the above query somewhere, so that we can run it whenever needed using one line?
-- We can store this query in an object and simply query that object.
-- For that, we create a view on top of query. View is just a stored query.
-- View cannot hold any data.

create view dedup_view as
select
	subquery.*
from (select 
	*,
    row_number() over (partition by id order by id) as dedup
from
	customer) as subquery
where dedup = 1;

-- To run the view:

select * from dedup_view;