Скачать или смотреть Common Table Expression (CTE) in SQL in Telugu

In this video i explained what is CTE, when we use CTE and Different use cases.

You can learn these
1) Query to delete duplicate records with using CTE and without using CTE
2) Finding employee hierarchy using Recursive CTE
3) Printing 1 to 100 numbers using CTE
4) Finding the Percentage of sales amount of a highest sales product in it's category IF EXISTS (SELECT * FROM SYS.TABLES WHERE NAME = 'EMP')
DROP TABLE EMP
GO

CREATE TABLE EMP
(
EMPNO NUMERIC(4) NOT NULL,
ENAME VARCHAR(10),
JOB VARCHAR(9),
MGR NUMERIC(4),
HIREDATE DATETIME,
SAL NUMERIC(7, 2),
COMM NUMERIC(7, 2),
DEPTNO NUMERIC(2)
)

INSERT INTO EMP VALUES (7369, 'SMITH', 'CLERK', 7902, '17-DEC-1980', 800, NULL, 20)
INSERT INTO EMP VALUES (7499, 'ALLEN', 'SALESMAN', 7698, '20-FEB-1981', 1600, 300, 30)
INSERT INTO EMP VALUES (7521, 'WARD', 'SALESMAN', 7698, '22-FEB-1981', 1250, 500, 30)
INSERT INTO EMP VALUES (7566, 'JONES', 'MANAGER', 7839, '2-APR-1981', 2975, NULL, 20)
INSERT INTO EMP VALUES (7654, 'MARTIN', 'SALESMAN', 7698, '28-SEP-1981', 1250, 1400, 30)
INSERT INTO EMP VALUES (7698, 'BLAKE', 'MANAGER', 7839, '1-MAY-1981', 2850, NULL, 30)
INSERT INTO EMP VALUES (7782, 'CLARK', 'MANAGER', 7839, '9-JUN-1981', 2450, NULL, 10)
INSERT INTO EMP VALUES (7788, 'SCOTT', 'ANALYST', 7566, '09-DEC-1982', 3000, NULL, 20)
INSERT INTO EMP VALUES (7839, 'KING', 'PRESIDENT', NULL, '17-NOV-1981', 5000, NULL, 10)
INSERT INTO EMP VALUES (7844, 'TURNER', 'SALESMAN', 7698, '8-SEP-1981', 1500, 0, 30)
INSERT INTO EMP VALUES (7876, 'ADAMS', 'CLERK', 7788, '12-JAN-1983', 1100, NULL, 20)
INSERT INTO EMP VALUES (7900, 'JAMES', 'CLERK', 7698, '3-DEC-1981', 950, NULL, 30)
INSERT INTO EMP VALUES (7902, 'FORD', 'ANALYST', 7566, '3-DEC-1981', 3000, NULL, 20)
INSERT INTO EMP VALUES (7934, 'MILLER', 'CLERK', 7782, '23-JAN-1982', 1300, NULL, 10)

GO
-- Create a table for Products
CREATE TABLE Products (
ProductID INT,
ProductName VARCHAR(50),
Category VARCHAR(50),
SalesAmount DECIMAL(10, 2)
);

-- Insert sample data
INSERT INTO Products (ProductID, ProductName, Category, SalesAmount)
VALUES
(1, 'Product A', 'Electronics', 5000.00),
(2, 'Product B', 'Electronics', 3200.00),
(3, 'Product C', 'Clothing', 4500.00),
(4, 'Product D', 'Clothing', 3800.00),
(5, 'Product E', 'Furniture', 6000.00),
(6, 'Product F', 'Furniture', 5500.00),
(7, 'Product G', 'Electronics', 4800.00),
(8, 'Product H', 'Clothing', 4200.00),
(9, 'Product I', 'Furniture', 5900.00),
(10, 'Product J', 'Electronics', 5600.00);