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:
• All About SQL Aggregations | SQL Advance |...
Most Asked Join Based Interview Question:
• Most Asked SQL JOIN based Interview Questi...
Solving 4 Trick SQL problems:
• Solving 4 Tricky SQL Problems
Data Analyst Spotify Case Study:
• Data Analyst Spotify Case Study | SQL Inte...
Top 10 SQL interview Questions:
• Top 10 SQL interview Questions and Answers...
Interview Question based on FULL OUTER JOIN:
• SQL Interview Question Based on Full Outer...
Playlist to master SQL :
• Complex SQL Questions for Interview Prepar...
Rank, Dense_Rank and Row_Number:
• RANK, DENSE_RANK, ROW_NUMBER SQL Analytica...
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
On this page of the site you can watch the video online first_value and last_value SQL window functions MASTER CLASS | Advance SQL with a duration of hours minute second in good quality, which was uploaded by the user Ankit Bansal 28 December 2022, share the link with friends and acquaintances, this video has already been watched 26,405 times on youtube and it was liked by 818 viewers. Enjoy your viewing!
