Hi All,
My name is Ankit Shrivastava and I am Data Engineer.
Today this #vlog is regarding mostly asked #sql #sqlinterviewquestions
How to calculate Running total/Cumulative Sum using #sql .
Also we have discussed how we can use UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING and CURRENT ROW with sql window function.
Please find the below DDL we have discussed for practice:-
create table sales
(
sales_id integer,sale_day date,sale_qty integer
)
drop table sales
insert into sales values (1,'01-01-2022',1);
insert into sales values (2,'02-01-2022',2);
insert into sales values (3,'03-01-2022',3);
insert into sales values (4,'04-01-2022',4);
insert into sales values (5,'05-01-2022',5);
insert into sales values (6,'06-01-2022',6);
insert into sales values (7,'07-01-2022',7);
insert into sales values (8,'08-01-2022',8);
insert into sales values (9,'09-01-2022',9);
insert into sales values (10,'10-01-2022',10); .
#sql #sqlinterviewquestions #interviewready #sqlcourse #sqlcommands #postgresql #dataanalytics #dataanalysis #dataanalyst
#sqlinterviewquestions #sqlinterviewquestionsandanswers #value
#sqlserver
#amazon #meta #walmart #google #databaseexercises #dataengineeringessentials #salary #oracle #sqlcourse #sqlinterview
#trendinginterview #cartesianproducts #interview #oracle #interviewtips #mysql #interviewready #interviewpreparation #sqljoins #dailylifeofdataengineer #dailyvlog #magic #sqlmagic
#highest #second #interviewready #interviewhacks #complex #complexscenario #scenarios #queries #plsql #sqlserver #postgresql #postgresql #trendinginterview #dataengineering #dataengineer #analyticfunction #unbounded #followinng #preceding #currentrow #running #runningtotal
Негізгі бет #sql
Пікірлер: 11