Скачать с ютуб Common Table Expression (CTE) in SQL in Telugu в хорошем качестве

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);