Leetcode Hard SQL Problem | Top 3 Highest salary department wise.
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
• Query To Find Maximum, Minimum and Average...
2.SQL Basic
• Introduction to Structured Query Language(...
3.SQL Advance Concept
• VIEWS IN SQL || WHY WE USE VIEWS IN SQL ||...
4. Tableau
• Funnel chart in Tableau || Tableau Tutorial
5. Python Tutorial
https://lnkd.in/dEcjgjSw
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');
