CTE (Common Table Expression ) IN SQL With Examples | Advance SQL Concept

Опубликовано: 04 Август 2022
на канале: Kraminka Verma.

126

In this video, I have discussed about CTE(Common Table Expression) with Examples .
Scroll down for Script.

Window Functions RANK(),DENSE_RANK(),ROW_NUMBER()
   • Window Analytical  Functions | RANK()...

1.SQL Interview Questions
   • Query To Find Maximum, Minimum and Av...

2.SQL Basic

   • Introduction to Structured Query Lang...

3.SQL Advance Concept

   • VIEWS IN SQL || WHY WE USE VIEWS IN S...

4. Tableau
   • Funnel chart in Tableau || Tableau Tu...

Script:-
create table Employees(

Id int,
Name varchar(20),
Salary int,
DepartmentId int
);

insert into Employees values(1,'Joe',70000,1),
(2,'Jim',90000,1),
(3,'Henry',80000,2),
(4,'Sam',60000,2),
(5,'Max',90000,1);

create table Department (

Id int,
Name varchar(20),
) ;

insert into Department values(1,'IT'),
(2,'Sales');