SQL interview Questions and Answers | Data Engineer Interview

#sqlinterviewquestionsandanswers #sql #sqlinterviewquestions
SQL interview Questions and Answers | SQL Interview Questions (Most Important)



# 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

[basedsonu]

I think dense rank is more suitable for this scenario as it will not increment rank if someone has same salary.

[luisrana]

I realized you were using TOP instead of LIMIT (for MySQL/Postgres). I was prepping for an exam and I was puzzled till I googled it that TOP is used for SQL Sever. Regardless, thanks for the insightful video!

[SuprajaBijjigiri-os]

As you are saying rank why are you using row_number

[noreply]

Kindly make a video on
"How to create student account for creating ADF account (without using credit card)"

[VinayAitha]

“TOP” doesnt work in data bricks… so we may need to learn to use “LIMIT” right ?

[lobzangpunchok]

Why ur using cte everywhere its not available inall database.

[office]

Can do you something like this for ADF & other things @learnbydoingit