Leetcode Hard SQL Problem | Top 3 Highest salary department wise.#sqlqueries #dataanalytics

In this video we will solve Leetcode SQL Problem and we will learn how to use CTE and Dense_rank() function.

1.SQL Interview Questions

2.SQL Basic

3.SQL Advance Concept

4. Tableau

5. Python Tutorial

script:
Create table Employee
(
id int,
name varchar(100),
salary int,
departmentId int
)

insert into Employee Values(1,'Joe',85000,1),
(2,'Henry',80000,2),
(3,'Sam',60000,2),
(4,'Max',90000,1),
(5,'Janet',69000,1),
(6,'Randy',85000,1),
(7,'Will',70000,1)

Create table Department
(
id int,
name varchar(100)
)
insert into Department values(1,'IT'),
(2,'Sales');

[Sirigineedi_Navann]

Nice topic 😊
Try to post at least a video on daily basis that would be more helpful 🎉