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 Tutorial
PySpark RealTime Scenarios playlist : • PySpark Real Time Scenarios
PySpark Interview Question : • PySpark Interview Series
Scenario Based Interview Question : • Scenario Based Interview Question
Unit Testing in PySpark : • UnitTesting PySpark
Linkedin : / pritam-saha-060516139
GitHub : https://github.com/Pritamsaha627/Pyspark
Contact Mail Id : [email protected]
Telegram channel : https://t.me/CognitiveCoders
Topmate : https://topmate.io/pritamsaha627
WhatsApp channel : https://whatsapp.com/channel/0029Va4x...
Instagram : / pritamsaha627
Travel & Food Vlogs : / @explorerpritamsaha
1 Subscriber, 1👍🏻, 1Comment = 100 Motivation 🙏🏼
🙏🏻Please Subscribe 🙏🏼
#pyspark #databricks #sql #bigdata #cognitivecoders