No video

SQL interview Questions and Answers | Data Engineer Interview

  Рет қаралды 9,078

learn by doing it

learn by doing it

Күн бұрын

#sqlinterviewquestionsandanswers #sql #sqlinterviewquestions
SQL interview Questions and Answers | SQL Interview Questions (Most Important)
AWS DATA ENGINEER : • AWS Data Engineer Basic
Azure data engineer playlist : • Azure Data Engineer
SQL PLAYLIST : • SQL playlist
Join telegram to discuss t.me/+Cb98j1_f...
sql table structure
CREATE TABLE [dbo].[employee](
[id] [int] NOT NULL,
[name] [varchar](30) NULL,
[post] [varchar](30) NULL,
[salary] [int] NULL,
[location] [varchar](20) NULL
)
INSERT [dbo].[employee] ([id], [name], [post], [salary], [location]) VALUES (1, N'sai', N'sse', 900000, N'UK')
GO
INSERT [dbo].[employee] ([id], [name], [post], [salary], [location]) VALUES (2, N'sree', N'se', 1000000, N'INDIA')
GO
INSERT [dbo].[employee] ([id], [name], [post], [salary], [location]) VALUES (3, N'manish', N'sde', 800000, N'INDIA')
GO
INSERT [dbo].[employee] ([id], [name], [post], [salary], [location]) VALUES (4, N'akki', N'se', 700000, N'USA')
GO
INSERT [dbo].[employee] ([id], [name], [post], [salary], [location]) VALUES (5, N'ani', N'se', 10000000, N'USA')
GO
INSERT [dbo].[employee] ([id], [name], [post], [salary], [location]) VALUES (6, N'rahul', N'sde', 20000, N'INDIA')
GO
INSERT [dbo].[employee] ([id], [name], [post], [salary], [location]) VALUES (7, N'negha', N'sse', 30000, N'UK')
GO
INSERT [dbo].[employee] ([id], [name], [post], [salary], [location]) VALUES (8, N'AA', NULL, 10000, N'UK')
tags :-
top 10 sql interview questions and answers,sql interview questions,sql questions,sql question and answers,sql interview question and answers,sql interview question,sql interview,top sql interview questions,sql interview questions and answers for freshers,sql interview preparation,sql query,sql interview questions for freshers,top sql questions,sql interview questions and answers for experienced,data science interview questions,data analyst,sql questions in hindi

Пікірлер: 13
@basedsonu
@basedsonu Ай бұрын
I think dense rank is more suitable for this scenario as it will not increment rank if someone has same salary.
@user-wg4bh3rv5i
@user-wg4bh3rv5i 3 ай бұрын
As you are saying rank why are you using row_number
@yogesh23mali
@yogesh23mali 7 ай бұрын
Useful content❤
@7thgorkha-zm4mc
@7thgorkha-zm4mc 8 ай бұрын
thanks
@noreply6500
@noreply6500 Жыл бұрын
Kindly make a video on "How to create student account for creating ADF account (without using credit card)"
@mohitbhatt4384
@mohitbhatt4384 9 ай бұрын
you cannot bro
@user-lt7li3lj4v
@user-lt7li3lj4v 11 ай бұрын
“TOP” doesnt work in data bricks… so we may need to learn to use “LIMIT” right ?
@learnbydoingit
@learnbydoingit 11 ай бұрын
Yes top will work in sql server
@redefinedshubham
@redefinedshubham 10 ай бұрын
It's giving error
@learnbydoingit
@learnbydoingit 10 ай бұрын
What is the error
@learnbydoingit
@learnbydoingit 10 ай бұрын
I have used sql server
@office4321
@office4321 3 ай бұрын
Can do you something like this for ADF & other things @learnbydoingit
@learnbydoingit
@learnbydoingit 3 ай бұрын
Sure
SQL interview Questions and Answers | Most Asked SQL Questions| part-3
8:28
SQL interview Questions and Answers | Data Engineer Interview
10:49
learn by doing it
Рет қаралды 21 М.
Or is Harriet Quinn good? #cosplay#joker #Harriet Quinn
00:20
佐助与鸣人
Рет қаралды 6 МЛН
OMG what happened??😳 filaretiki family✨ #social
01:00
Filaretiki
Рет қаралды 13 МЛН
女孩妒忌小丑女? #小丑#shorts
00:34
好人小丑
Рет қаралды 84 МЛН
ISSEI & yellow girl 💛
00:33
ISSEI / いっせい
Рет қаралды 25 МЛН
Top 10+ Data Engineer Interview Questions and Answers
13:18
Jay Feng
Рет қаралды 78 М.
How To Prepare For A Data Engineering Interview
14:12
Seattle Data Guy
Рет қаралды 53 М.
The 25 SQL Questions You MUST Know for Data Analyst Interviews
32:47
KSR Datavizon
Рет қаралды 215 М.
Or is Harriet Quinn good? #cosplay#joker #Harriet Quinn
00:20
佐助与鸣人
Рет қаралды 6 МЛН