sql scenario based interview questions and answers | sql

No video

sql scenario based interview questions and answers | sql | interview

Рет қаралды 642

Күн бұрын

sql scenario based interview questions and answers
sql
interview
Create Table Code :
================
create table celebrities
( celebrity_name varchar(30)
);
insert into celebrities values
('Virat Kohli')
,('Narendra Damodardas Modi')
,('Salman');
Need Help ? Connect With me 1:1 - topmate.io/dew...
Let's connect on LinkedIn : / dhirajgupta141
pyspark 30 days challenge : • pyspark 30 days challenge
top interview question and answer in pyspark :
• top interview question...
PySpark Installation and Setup : • Spark Installation | P...
DSA In Python Interview Series : • dsa for data engineer ...
PySpark Interview Series : • pyspark interview ques...
Pandas Interview Series : • pandas interview quest...
SQL Interview Series : • sql interview question...
#sql #pyspark #youtube #dataengineers #coding #interview #faang

Пікірлер: 5

@gudiatoka 3 ай бұрын

Brother please make video on regular basis❤

@DEwithDhairy 3 ай бұрын

PySpark Version of this problem : kzfaq.info/get/bejne/kNhmiLuX2dTVf4k.html

@ShubhamRai06 3 ай бұрын

in most of the cases there are more than 1 middle names.

@chaitanyadudgikar9806 3 ай бұрын

What if middle name includes 2 names?

@CEMANIVANNAN 2 ай бұрын

select celebrity_name,case when regexp_count(celebrity_name,' ')=1 then split_part(celebrity_name,' ',1) when regexp_count(celebrity_name,' ')=2 then split_part(celebrity_name,' ',1) else celebrity_name end first_name, case when regexp_count(celebrity_name,' ')=1 then null when regexp_count(celebrity_name,' ')=2 then split_part(celebrity_name,' ',2) end middle_name, case when regexp_count(celebrity_name,' ')=1 then split_part(celebrity_name,' ',-1) when regexp_count(celebrity_name,' ')=2 then split_part(celebrity_name,' ',-1) end last_name, from celebrities;--snowflake