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 Adva...

Most Asked Join Based Interview Question:
Most Asked SQL JOIN based Interview Q...

Solving 4 Trick SQL problems:
Solving 4 Tricky SQL Problems

Data Analyst Spotify Case Study:
Data Analyst Spotify Case Study | SQL...

Top 10 SQL interview Questions:
Top 10 SQL interview Questions and An...

Interview Question based on FULL OUTER JOIN:
SQL Interview Question Based on Full ...

Playlist to master SQL :
Complex SQL Questions for Interview P...

Rank, Dense_Rank and Row_Number:
RANK, DENSE_RANK, ROW_NUMBER SQL Anal...

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

• #science_technology
• #sql
• #sql_window_functions
• #sql_first_value_function
• #sql_first_and_last_value_functions
• #sql_last_value_function
• #sql_master_class