Top 10 SQL interview Questions and Answers | Frequently asked SQL interview questions. 

Master the art of SQL @ Rs 1999 with my zero to hero SQL course. The course is focused on data analytics and covers all the advanced concepts starting from scratch. www.namastesql.com/courses/SQL-For-Analytics-6301f405e4b0238f71788354 Course contains 2 portfolio projects and a bonus session on Tableau. 100+ interview problems to crack any SQL INTERVIEW.

create table emp( emp_id int, emp_name varchar(20), department_id int, salary int, manager_id int, emp_age int); insert into emp values (1, 'Ankit', 100,10000, 4, 39; insert into emp values (2, 'Mohit', 100, 15000, 5, 48); insert into emp values (3, 'Vikas', 100, 10000,4,37); insert into emp values (4, 'Rohit', 100, 5000, 2, 16); insert into emp values (5, 'Mudit', 200, 12000, 6,55); insert into emp values (6, 'Agam', 200, 12000,2, 14); insert into emp values (7, 'Sanjay', 200, 9000, 2,13); insert into emp values (8, 'Ashish', 200,5000,2,12); insert into emp values (9, 'Mukesh',300,6000,6,51); insert into emp values (10, 'Rakesh',300,7000,6,50);

Crisp & insightful

Literally great. In all my SQL interviews one or the other is asked. Subscribed

Your videos are very good and helpful. Thank you for providing data with create and insert statements.

very simple way to explain...Nice!

Really Master class videos Ankit, Thanks.

Thnks for the video. Very helpful 👍

Wow it wsd asked today delete duplicates..thanks for the videos.it is really really helpful

simple and clear explanation!!

Good explanation👏 Please do more intermediate and advanced level of concepts in SQL.

Very well explained... 👌

Thank for the video 🙏

Tqsm for awesome explanation 🔥

Great video! Loved that last question. Subbed and eager to practice more SQL with your other videos

Thanks for this!

Just landed here bro you are doing amazing job

yeah it was really important vid as see for the interveiw sceneriao

Bang on ! Started product based companies interview prepration for Sr. DE role ( Google/Microsoft/Ubder/Amazon/Expedia / AirBnB) etc...and your content is crisp and clear. Thanks

For the First time in 10 years, I am feeling confident with using SQL, only after watching your series of videos. Earlier I used Python to do data preprocessing after doing Vanilla Select * from Table Statement, which was not a recommended approach for memory efficiency.

Million thanks

Awesome

You just earned a subscribe from me bro. I haven't used SQL in years, but due to a career change I'm planning to have soon, I'll need to learn more about SQL in-depth alongside bettering my skillset in C++ programming.

It will be helpful if you can create videos on views and stored procedures

Great video, I took down some notes!

finished watching

Great content. Thank you Ankit

You just earned a subscriber really great content🥺

Thanks 👍

Thanks ankit, ur videos always encourage and boost confidence to prac more n go beyond our limit. Thanks Man

Just loving your content.. Very well explained.

thanks, it actually let me through so i could download it.

keep doing more videos like it. It really helped me in my job interview today. I am able to answer the question of how to remove duplicates from a table because of your videos.

Good one .. !!

Thanks Ankit its very helpful in interivews wish i had come across your videos early.. thnks much

Thanks for this video.

Very Useful...I hope part2 will come soon

DDL and Insert values for emp table. create table emp( emp_id int, emp_name varchar(20), department_id int, salary int, manager_id int, emp_age int); insert into emp values (1, 'Ankit', 100,10000, 4, 39), (2, 'Mohit', 100, 15000, 5, 48), (3, 'Vikas', 100, 10000,4,37), (4, 'Rohit', 100, 5000, 2, 16), (5, 'Mudit', 200, 12000, 6,55), (6, 'Agam', 200, 12000,2, 14), (7, 'Sanjay', 200, 9000, 2,13), (8, 'Ashish', 200,5000,2,12), (9, 'Mukesh',300,6000,6,51), (10, 'Rakesh',300,7000,6,50);

Hi Ankit, loved your all videos. Looking forward to see a video on subqueries,

Very Good explanation!

Amazing video, tomorrow I have an interview, I was clueless how to start and where to start, now I know what to do for tomorrow :)) Thanks for sharing :)

Thanks a lot, Learned lots of new concepts.

Beautiful presentation

thanks Ankit..good tutorial..

Thanks sir for this amazing video

I guess we can use subquery table as a normal table to display information using alias and where clause , but when it comes to comparison it needs to return only 1 value :) !!

very helpful ..thanks

Thanks brother, nice explanation

I have subscribed and liked . you are doing wonderful job

Very helpful sir, thank you!

Hi Ankit, first of all this is really a great initiative that you are sharing all this knowledge and explaining the complex queries in a very easy way. And because of this I am really glad to tell you that your channel has majorly helped me to crack one of the SQL interview. Thank you so much for such a great effort and we all wish to see some more complex queries and concepts in coming future, once again thank you so much. Wish you a great health!

Thanks

revised today for deloiite interview and suscribed too

Superb video..liked every second of the video 💖

Ankit, I love your educational content. Is it possible for you to record the whole PL/SQL course for beginner/Intermediates?

5/123 Stuck with 2 ques , coz i'm using mysql

I am watching your one video each morning. So one day I will work as data engineer in good product based company.

Love your valuable contents. I have few question sets from facing different screening. Can I share with you for help with solutions? Your way of explanation helps a lot

Thank you so much. Make vidoes on JOINS.

Please make a playlist for sql for the beginners which includes everything like joins, Subquery, functions which used in ms sql..

please make a part 2 of this video Ankit. thank you for your efforts

You are doing really awesome. Please keep doing this. One suggestion: Please don't forget to add create table script.

Wonderful crisp and short explanation Ankit. I have my interviews lined up can you share resources for SQL interview questions, Data Modelling and Normalization scenario based questions? I know all basics and all theories but I want to practice on questions which have answers as well.

Thank you bro

you don't need the motivation from others because, you yourself is a motivation 🤗

Just wanted to know can we use left anti join for the 5th question?

for better reach, keep creating content

Sir pls make latest interview sql quetions

Q7. MSSQL does not depend on case-sensitive but in the Oracle is depend on the case-sensitive

hi Ankit , can you please make some videos for product based companies. Thank yoou for your effort. Appriciatable

Ankit bhai if you have time can you solve some hacker rank test questions for better understanding for people who are learning sql newly..that would be helpfull

can you make a video on stored procedures.. from basic to everything needed to know

Wow such a nice content. Please zoom a bit while making videos. Because most audience watch it over phone it strain the eyes

Hi, Ankit. you made them look so easy. Thank you💌. it would be great if you could provide the code of the creation of tables so i can practice it on my workbench.

Done

Hello Ankit, I have onre request along with the explanation if you can share the create table command as well , will be helpful to dummy it to my own schema. Like here employee table

what if i wanna to swap from row 4 and 5 value , I think 'case' only do for the first occurrences of match value.Thus why, only the first two rows are evaluated with case clause and rest remain the same. Is it true bhai? I am not clear about it. Plz shed some light .

I asked a question a employee enters and leaves office and he swipes in and swipes out in multiple instances, so I want to find the total office hours he spent in the office( he may come at 10 PM and take a break at 12:30 AM in that case it shows that he is spending 2 hours in that day but that's not true right), so now I have to calculate total time he spent employee id, Office_swipe_record given

Sir please raise the editor font more than 130% while recording , coz it's very hard to watch on the phone

In the 2 question, delete from cte is written so how the records got deleted from original table

Performance wise why joins are better than subqurey??

❤

@Ankit , Requesting you to add more scenario based SQL questions mostly asked in NICHE Product based companies, would be helpful.

#For swap gender : update orders set customer_gender=IF(customer_gender='Male','Female','Male');

Helpful video, Thanks. could you please share the dataset used in the video, to practice please.

Delete duplicate records query in not working in databricks notebook for deleting duplicate records from a table.. is there any way to do this in databricks notebook table? @ankit

1m likes 👍

Thanks for this Video. I have one doubt, Question number 2. How to delete duplicates from a table? Shall we do it in mysql? I tried but I didn't get correct result.

@Ankit Bansal bhai if we have left whats the use of right join ?

Hi Ankit , i start following your tutorial , it is really helpful . nut i am not able to connect SSMS at my local computer , can you please help me what should be server name . i am using SSMS 2019

Yes, you are absolutely right, Many questions are based on your teaching. Thanks again for this great help Ankit!!

In 2nd Question of removing duplicates: We are deleting values from the CTE table which is a TEMP table. Then how it is deleting values from the MAIN table?

Good content, i have a question why table name used as emp1, it should be emp right?

What is the difference between union and union distinct

Hello ankit, Seems like you have lots of videos but not in a playlist, for ex: I want to start from the beginner level and then moved to medium then hard queries. I have seen your playlist but lots of videos aren't there where you are explaining things like the date function, and rank function, If it's in a playlist/series then it would be easier for us to go through step by step. Let me know if you already have or i have missed something.

Diff between count* and count1

is this the hardest question for sql interview ?

Can you please tell me how to delete duplicates in mysql?

Hi Ankit, till now I don’t know we can even delete the records from cte rather from actual table, could you please tell more about this

in union it will also SORT the result