SQL WINDOW FUNCTION(PART1) | PARTITION BY | FRAME |UNBOUNDED PRECEDING | UNBOUNDED FOLLOWING(HINDI)

SQL script: create database sql_questions; use sql_questions; create table emp( EMPNO int, EMPNAME varchar(255), JOB varchar(255), HIREDATE date, SALARY int, BONUS int, DEPTNO int ); insert into emp(EMPNO, EMPNAME, JOB, HIREDATE, SALARY, BONUS, DEPTNO) values(1609, 'David','HR','2020-12-17', 800, null, 20), (1499, 'Thomas','DATA SCIENTIST', '2021-02-20', 1600, 300, 30), (1121, 'Charles','DATA SCIENTIST', '2021-02-22', 1250, 500, 30), (1366, 'Ethan','DATA ANALYST', '2021-04-02', 2975, null, 20), (1454, 'Robert','DATA SCIENTIST', '2021-09-28', 1250, 1400, 30), (1658, 'Harry','DATA ANALYST', '2021-05-01', 2850, null, 30), (1282, 'Alexander','DATA ANALYST', '2021-06-09', 2450, null, 10), (1588, 'Henry','BUSINESS ANALYST', '2022-12-09', 3000, null, 20), (1939, 'Benjamin','PRESIDENT', '2021-11-17', 5000, null, 10), (1844, 'Arthur','DATA SCIENTIST', '2021-09-08', 1500, 0, 30), (1476, 'Abigail','HR', '2023-01-02', 1100, null, 20), (1900, 'Olivia','HR', '2020-12-03', 950, null, 30), (1902, 'Daniel','ANALYST', '2020-12-03', 3000, null, 20), (1934, 'Michael','HR', '2021-01-23', 1300, null, 10) ; Queries Solved!!! SQL WINDOWS FUNCTION Master these concepts to crack data scientist, data analyst roles: ▪ SUM() OVER() ▪ Partiton By ▪ Frames ▪ Unbounded Preceding ▪ Unbounded Following Data Scientist | Data analyst |Business Analyst interview questions ====================================================== Follow Me On Social Media ►LINKEDIN:   / tushar-bansal-1a2377122   ►INSTAGRAM:   / mlmonk_   ====================================================== ►FOR COLLABORATION AND BUSINESS INQUIRY: tushar8bansal@gmail.com ►DON'T FORGET TO LIKE, COMMENT, SHARE, AND SUBSCRIBE!!! tHANK yOU sO mUCH fOR wATCHING !!!