SQL Tips and Tricks - first_value and last_value SQL window functions MASTER CLASS | Advance SQL

In this video we are going to discuss 2 important SQL window functions first value and last value. We will discuss them in detail and talk about some important issues with the last value function. Zero to hero(Advance) SQL Aggregation: https://youtu.be/5Ighj_2PGV0 Most Asked Join Based Interview Question: https://youtu.be/xR87ctOgpAE Solving 4 Trick SQL problems: https://youtu.be/Ck1gQrlS5pQ Data Analyst Spotify Case Study: https://youtu.be/-YdAIMjHZrM Top 10 SQL interview Questions: https://youtu.be/Iv9qBz-cyVA Interview Question based on FULL OUTER JOIN: https://youtu.be/KQfWd6V3IB8 Playlist to master SQL : https://youtube.com/playlist?list=PLBTZqjSKn0IeKBQDjLmzisazhqQy4iGkb Rank, Dense_Rank and Row_Number: https://youtu.be/xMWEVFC4FOk script: create table employee( emp_id int, emp_name varchar(20), dept_id int, salary int, manager_id int, emp_age int ); insert into employee values(1,'Ankit',100,10000,4,39); insert into employee values(2,'Mohit',100,15000,5,48); insert into employee values(3,'Vikas',100,10000,4,37); insert into employee values(4,'Rohit',100,5000,2,16); insert into employee values(5,'Mudit',200,12000,6,55); insert into employee values(6,'Agam',200,12000,2,14); insert into employee values(7,'Sanjay',200,9000,2,13); insert into employee values(8,'Ashish',200,5000,2,12); insert into employee values(9,'Mukesh',300,6000,6,51); insert into employee values(10,'Rakesh',500,7000,6,50); #sql #advanced