BandhanBank SQL Interview Questions and Answers | Data Engineering | SQL Interview Question

CREATE TABLE employee(
emp_id int,
name varchar(50),
department varchar(50),
manager_id int,
salary varchar(50))
INSERT INTO employee (emp_id,name,department,manager_id,salary) VALUES (1,'Virat','IT',NULL,8000),(2,'Rohit','IT',NULL,8000),(3,'Pant','Finance',1,7000),(4,'Rahul','Finance',2,6000),(5,'Sanju','HR',1,5000),(6,'Rinku','HR',3,4000),(7,'Bumrah','Admin',NULL,7000),(8,'Shami','Admin',7,6000),(9,'Siraj','BPO',3,5000),(10,'Axar','BPO',1,5500)
If you like this video please do like,share and subscribe my channel.
PySpark playlist : • PySpark and Databricks
Azure Datafactory playlist : • Azure Data Factory Tut...
PySpark RealTime Scenarios playlist : • PySpark Real Time Scen...
PySpark Interview Question : • PySpark Interview Series
Scenario Based Interview Question : • Scenario Based Intervi...
Unit Testing in PySpark : • UnitTesting PySpark
Linkedin : / pritam-saha-060516139
GitHub : github.com/Pri...
Contact Mail Id : [e-mail]
Telegram channel : t.me/Cognitive...
Topmate : topmate.io/pri...
WhatsApp channel : whatsapp.com/c...
Instagram : / pritamsaha627
Travel & Food Vlogs : / @pritamsaha627
1 Subscriber, 1👍🏻, 1Comment = 100 Motivation 🙏🏼
🙏🏻Please Subscribe 🙏🏼
#pyspark #databricks #sql #bigdata #cognitivecoders

[@prajwalreddy2882]

with cte as (select * from employee e1
where not exists ( select 1 from employee e2
where e1.emp_id = e2.manager_id)),
cte2 as (select department ,emp_id, dense_rank() over(partition by department order by salary desc ) as dnk from cte)
select department, emp_id,dnk from cte2
where dnk= 1;

[@chandanpatra1053]

Bro please provide create and insert statement. Already you have made so many videos. These things shouldn't be reminded.😢😢😢😢

[@CognitiveCoders]

Always collect it from our telegram channel when it's not given in description.

[@sabesanj5509]

Bro first add the question in either comments or description section.