Top 10 SQL interview Questions and Answers | Frequently asked SQL interview questions.
HTML-код
- Опубликовано: 15 янв 2022
- In this video we will discuss most frequently asked top 10 SQL interview questions. If you have any interview I am sure 2-3 questions will be from this list.
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.
Is it in udemy ?
@@avinashmishra4995 nope
@@ankitbansal6 bro i really need your help.. is there any way i can reach out to you..
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?
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);
Thank you 😊
thanks
god bless you
create table orders(
customer_name char(10),
order_date date,
order_amount int,
customer_gender char(6)
);
insert into orders values('Shilpa','2020-01-01',10000,'Male');
insert into orders values('Rahul','2020-01-02',12000,'Female');
insert into orders values('Shilpa','2020-01-02',12000,'Male');
insert into orders values('Rohit','2020-01-03',15000,'Female');
insert into orders values('Shilpa','2020-01-03',14000,'Male');
create table department(
dept_id int,
dept_name varchar(10)
);
insert into department values(100,'Analytics');
insert into department values(300,'IT');
Crisp & insightful
Literally great.
In all my SQL interviews one or the other is asked.
Subscribed
Really Master class videos Ankit, Thanks.
Your videos are very good and helpful. Thank you for providing data with create and insert statements.
Thnks for the video. Very helpful 👍
very simple way to explain...Nice!
Good explanation👏 Please do more intermediate and advanced level of concepts in SQL.
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.
This is great. Best place to play with data is where it is residing 😊
Wow it wsd asked today delete duplicates..thanks for the videos.it is really really helpful
Very well explained... 👌
Great video! Loved that last question. Subbed and eager to practice more SQL with your other videos
🙏🙏
Thank for the video 🙏
Just landed here bro you are doing amazing job
simple and clear explanation!!
It will be helpful if you can create videos on views and stored procedures
Tqsm for awesome explanation 🔥
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.
Cool. Thank you 😊
Great video, I took down some notes!
yeah it was really important vid as see for the interveiw sceneriao
Thanks for this!
Good one .. !!
Glad you liked it
Awesome
You just earned a subscriber really great content🥺
thanks, it actually let me through so i could download it.
Great content. Thank you Ankit
Thanks a ton
Thanks ankit, ur videos always encourage and boost confidence to prac more n go beyond our limit. Thanks Man
Keep it up
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!
Hey for which position you cleared the interview. And you cleared it as a fresher or experienced. Please reply.
Very Useful...I hope part2 will come soon
Yes it will
Hi Ankit, loved your all videos. Looking forward to see a video on subqueries,
Sure 🙂
Thanks Ankit its very helpful in interivews wish i had come across your videos early.. thnks much
Thank you 😊
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.
Great job!
Thanks for this video.
Glad you liked it 😊
Just loving your content.. Very well explained.
Happy to hear that!
Million thanks
finished watching
Ankit, I love your educational content. Is it possible for you to record the whole PL/SQL course for beginner/Intermediates?
Thank you. I will plan in future 🙂
Ankit sir added humour silently in this video with q10 😃
Superb video..liked every second of the video 💖
Thank you! Cheers!
Very Good explanation!
Glad it was helpful!
Thanks 👍
Thanks sir for this amazing video
Most welcome
Thanks a lot, Learned lots of new concepts.
Glad to hear that!
revised today for deloiite interview and suscribed too
Cool . all the best.
I have subscribed and liked . you are doing wonderful job
Thank you so much 😀
Thanks brother, nice explanation
Thank you
Very helpful sir, thank you!
You are welcome!
Beautiful presentation
Thank you! Cheers!
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 :)
Best of luck!
Thank you sir :))
thanks Ankit..good tutorial..
Thank you 😊
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
Sure send me on ankitbansal1988@gmail.com
very helpful ..thanks
Glad it was helpful!
I am watching your one video each morning.
So one day I will work as data engineer in good product based company.
Thats a great way of preparing yourself 😊🙏
Thank you so much.
Make vidoes on JOINS.
Sure
You are doing really awesome. Please keep doing this.
One suggestion: Please don't forget to add create table script.
Thank you. Scripts are there in most of the video description box. Might have missed few in my initial videos. Will put them soon.
@@ankitbansal6 Cool
for better reach, keep creating content
sure.
Please make a playlist for sql for the beginners which includes everything like joins, Subquery, functions which used in ms sql..
Sure. I have that in plan.
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);
Thanks brother 😊
@@ankitbansal6 welcome ☺
Wow such a nice content. Please zoom a bit while making videos. Because most audience watch it over phone it strain the eyes
Sure
please make a part 2 of this video Ankit.
thank you for your efforts
Sure I will
Thanks
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.
Thanks Dhiraj. You can practice more from leetcode.
5/123
Stuck with 2 ques , coz i'm using mysql
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 :) !!
hi Ankit , can you please make some videos for product based companies. Thank yoou for your effort. Appriciatable
I have a lot of them. Check out complex SQL playlist
Just wanted to know can we use left anti join for the 5th question?
Thank you bro
Welcome
Sir pls make latest interview sql quetions
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
Do you have some links to the good problems?
@Ankit , Requesting you to add more scenario based SQL questions mostly asked in NICHE Product based companies, would be helpful.
Sure
Yes, you are absolutely right, Many questions are based on your teaching. Thanks again for this great help Ankit!!
Good to know 😊
can you make a video on stored procedures.. from basic to everything needed to know
Sure will plan.
you don't need the motivation from others because, you yourself is a motivation 🤗
🙏
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 .
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
I have create and insert in most of the problems description. I will make sure I don't miss in future. Thanks for pointing out 😊
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.
It's there in the comments section
Sir please raise the editor font more than 130% while recording , coz it's very hard to watch on the phone
1m likes 👍
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.
SQL tips and tricks is the playlist
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
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.
+1
Performance wise why joins are better than subqurey??
@Ankit Bansal bhai if we have left whats the use of right join ?
Not required 😁
❤
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
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
It works only in SQL server
#For swap gender :
update orders
set customer_gender=IF(customer_gender='Male','Female','Male');
Q7. MSSQL does not depend on case-sensitive but in the Oracle is depend on the case-sensitive
Helpful video, Thanks.
could you please share the dataset used in the video, to practice please.
It's there in the comments section
Good content, i have a question why table name used as emp1, it should be emp right?
Simply
In the 2 question, delete from cte is written so how the records got deleted from original table
Your approach to Delete duplicate valuse from the table is not working in my sql (gettting this pop up "The target table cte1 of the DELETE is not updatable")
Hi, I've got a query here.
In the 2nd question, we are deleting the duplicate values from cte, how is it getting reflected in emp1 table?
+1 to the question. Also @AnkitBansal, why did we go ahead and use Partiton concept to find and delete duplicate and why couldnt we have used the first logic of count(1) and use it in where clause and delete the entries cause thats what we actually did with rownumber as well. isn't it?
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
Localhost
Make sure you have installed SQL server as well. ssms is just a client to access data base
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?
Done
What is the difference between union and union distinct
Can you please tell me how to delete duplicates in mysql?