SQL|| Recursive CTE || Department wise highest salary #sql #sqlserver #database

#sql #sqlserver #database
Table Script

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)

-------------------------------------------------------------------------------------------------------------------------------------

Hello Everyone - Welcome to NityaCloudtech!!
* How to find Department Wise Highest Salary?
* Top 2 SQL Question & Answer
* Recursive CTE Example

Subscribe my channel for Free learning and Job assistance.

We have below step by step tutoraial along with real time scenerias and channel is keep updaing on Regular Frequencies.

Azure Data Factory||Azure Databricks||Python Automation Series||Python for Data Science||Power BI||Python Power BI Integration||Azure Synapse

---------------------------------------------------------------------------------------------------------------
All Playlist in my channel

-------------------------------------------------------------------------------------------------------------

Please donate if you want to support the channel through Phonepay.

-----------------------------------------------------------------------------------------------------------

Please join as a member in my channel to get additional benefits like materials in Power BI, Python for Data Science, live streaming for Members
and many more.

-------------------------------------------------------------------------------------------------------
For any business inquiries, Connect with me here: