SQL Queries Interview Questions and answers

Best 30 SQL Queries Interview Question and answers which every candidate should definitely prepare.
Please like & share the video.
Create table for practicing queries: drive.google.c...
Try and attempt Multiple Choice Questions below and do comment if you like the MCQ:
forms.gle/4NHa...
Check out Solutions: • SQL MCQ Questions & An...
Subscribe the Channel to keep watching interesting videos helpful for your career growth:
/ @codingglitz
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Checkout different playlists:
PLSQL Tutorial : • PLSQL Tutorial || PL S...
Learn DBMS & SQL : • SQL Tutorial for Begin...
SQL Interview Questions and answers: • sql interview question...
Interview Tips : • Interview Tips
--------------------------------------------------
--------------------------------------------------
Checkout Important videos :
Top 30 SQL Queries Interview Questions and Answers : • SQL Queries Interview ...
Top 50 SQL Concepts Interview Questions and Answers : • SQL Interview Question...
SQL JOINS : • SQL Joins With Example...
SUB QUERY : • Subquery in SQL || SQL...
Employee earning maximum salary in each department query : • SQL Query to find Empl...
How to find Nth highest salary (3 different solutions): • SQL query to find Nth ...
Tricky SQL Queries Part1 : • SQL Tricky and Importa...
AGGREGATE FUNCTION: • Aggregate function ||...
GROUP BY : • GROUP BY & HAVING || ...
How to practice SQL Queries in local / Install Database in local : • How to Install Oracle ...
IT Jobs without Coding : • IT Jobs without coding...
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
You can directly go to individual questions on clicking on the timestamp :
1. SQL Query to update DateOfJoining to 15-jul-2012 for empid =1 : 04:39
2. SQL Query to select all student name where age is greater than 22 : 06:13
3. SQL Query to Find all employee with Salary between 40000 and 80000 : 06:38
4. SQL Query to display full name : 08:26
5. SQL Query to find name of employee beginning with S : 07:22
6. Write a query to fetch details of employees whose firstname ends with an alphabet ‘A’ and contains exactly five alphabets : 09:36
7. Write a query to fetch details of all employees excluding few Employees : 10:53
8. SQL query to display the current date : 12:11
9. SQL Query to get day of last day of the previous month : 13:13
10. Write an SQL query to fetch the employee FIRST names and replace the A with ‘@’ : 14:42
11. Write an SQL query to fetch the domain from an email address : 15:35
12. Write an SQL query to update the employee names by removing leading and trailing spaces : 17:16
13. Write an SQL query to fetch all the Employees details from Employee table who joined in the Year 2020 : 17:54
14. Write an SQL query to fetch only odd rows / Even rows from the table : 19:21
15. Write an SQL query to create a new table with data and structure copied from another table : 20:35
16. Write an SQL query to create an empty table with the same structure as some other table : 20:35
17. Write an SQL query to fetch top 3 HIGHEST salaries : 22:31
18. Find the first employee and last employee from employee table : 24:12
19. List the ways to get the count of records in a table : 25:17
20. Write a query to fetch the department-wise count of employees sorted by department’s count in ascending order : 26:25
21. Write a query to retrieve Departments who have less than 4 employees working in it : 27:12
22. Write a query to retrieve Department wise Maximum salary : 28:25
23. Write a query to Employee earning maximum salary in his department : 28:42
24. Write an SQL query to fetch the first 50% records from a table : 31:19
25. Query to fetch details of employees not having computer : 34:47
26. Query to fetch employee details along with the computer details who have been assigned with a computer : 32:54
27. Fetch all employee details along with the computer name assigned to them : 35:43
28. Fetch all Computer Details along with employee name using it : 38:41
29. Delete duplicate records from a table : 39:51
30. Find Nth Highest salary : 43:58

[@CodingGlitz]

LinkedIn: www.linkedin.com/in/biplabparida Try and attempt Multiple Choice Questions below and do comment if you like the MCQ. forms.gle/4NHaRjoqFbYrgqrg9 Check out Solutions: kzbin.info/www/bejne/qYeTpKqKo7yWaKs Checkout the below doc for creating the table used in this video: docs.google.com/document/d/1Xv9xCNTGZm4SuAlR5hmzOoraq_Jc2YIZ/edit?usp=sharing&ouid=108295025764141437347&rtpof=true&sd=true

[@webxplore4746]

which SQL editor you have used in this video ?

[@CodingGlitz]

SQL Developer

[@curious_bird]

Sir Please Send the link of data you have used in this video. I need to practice it.

[@CodingGlitz]

@@curious_bird checkout: docs.google.com/document/d/1Xv9xCNTGZm4SuAlR5hmzOoraq_Jc2YIZ/edit?usp=sharing&ouid=108295025764141437347&rtpof=true&sd=true

[@NitinKumar-dx5pl]

28:48 28:51

[@yogenderkushwaha5523]

Thanks for the video man. Got selected in one of the company just by seeing 2 videos of SQL interviews questions and queries from your channel. ❤️

[@CodingGlitz]

Congratulations 🎊😃

[@mahesh1724]

Hi sir.. I am also learning SQL .. which company u joined sir.. please guide me

[@born_ambitious]

I am searching for job in sql and linux..but didn't get a single call from any company

[@suvarna625]

Also mention which videos so that it would be helpful to lot more people

[@kingdomtrainings]

For 12th question instead of using (Ltrim(Rtrim)) we can use directly Trim(columname) if we use two functions ltrim(rtrim) unnecessarily it will decrease the performance. Instead we can use only one function which will give the exact result. Trim(Columnname) this will remove the trailing spaces from both sides. Hope this helps👍

[@CodingGlitz]

Correct..

[@fact8604]

Ur teaching style is awesome. Lucky to have ur lecture.

[@AparajitaJena-cy3mp]

Your explanations are incredibly clear and insightful! Would you be open to tackling some LeetCode questions as well ?

[@nicksaha1021]

Sir 13th question ka ans. Apka alag hai kyu ki usme employee details mangi h jiski doj 2020 ho. Iske liye we can write :- Select * from employee Where date of join like '%2020' Select * from employee Where year(date of join) = '2020'

[@shubhamsahu1352]

Sir no one on this planet is teaching like u .u r explaining everything from the scratch ❤ thanks sir

[@CodingGlitz]

Thanks bhai

[@vinamra95]

Nice.... Badhia revision ho gya interview ke pehle

[@CodingGlitz]

All the best for interview.

[@patel_05_roma]

The Way of teaching is excellent💯👍👏 good job keep it up

[@CodingGlitz]

Thanks 😊

[@kostavdg]

Quite a helpful video !! Awesome. A must Subscribed channel.✌👌

[@CodingGlitz]

Thanks ☺️

[@neerajmalviya31]

Nic lecture

[@shravanikeni6218]

Your teaching is awesome ❤

[@CodingGlitz]

🙂

[@poonamgharge6189]

Really helpful thank you sir.

[@akshaykharche6726]

Really great Bro! Nice pin-point explanation done in the video. Just one thing can we get database so we can practice this on our pc!.. Thanks in advance 👍

[@CodingGlitz]

Thanks.. Sure you can install Oracle database and I use SQL developer IDE which you can also install. kzbin.info/www/bejne/aIOvqnqXbsmlbqM

[@sanjeebamat4485]

It is really helpful and almost covered all query in sql also make video Store procedure,triger ,function thanks a lot ❤

[@CodingGlitz]

Thanks!! .. Please checkout the PL SQL Playlist for Stored Procedures, Triggers, functions, etc. kzbin.info/aero/PLKVxK2jv1oA-LwzbMlOFZS-CgbucH5OhQ

[@Aditya_Kulkarni_BACS]

30th solution SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET n-1;

[@madhueducation143]

Nice

[@There_is_no_God_but__ALLAH]

Thanks for sharing such quality of knowledge 🥇🥇🥇🥇🥇🥇🥇🥇🥇🥇

[@ghanshyam014]

I almost done by practicing , Good Content collection and Good presentation 👍

[@Sneha-yn4zx]

I learnt so many things from you thank you so much

[@CodingGlitz]

Glad it helped ☺️

[@jyotikothari499]

Good explanation

[@HakikatStudios]

Good 👍

[@CodingGlitz]

Thanks, 🙂

[@MND44]

Helpfull content...thank you bro

[@aryasunil9041]

This video was extremely helpful for my placements

[@CodingGlitz]

All d very best for future.😊

[@vasimuddinsheikh3766]

Have you got the job?

[@lilyfullery4779]

Thanks for the video .

[@vivekkapil4571]

Awesome video and it would really helpful for SQL journy 🎉thanks wish your channel gets more user 😇

[@CodingGlitz]

Thanks for watching. Please watch SQL playlist as well 🙂

[@snehayadavbpylbpbkdi1758]

One from non tech can easily understand your lectures. I'm starting your SQL beginner list but I'm not sure if your important SQL queries playlist is part of it or not. Can you please confirm?

[@CodingGlitz]

SQL Tutorial for Beginners || SQL Playlist Hindi: kzbin.info/aero/PLKVxK2jv1oA9Ow28rg__JaBWjJQtoPyu6

[@beingcheercool]

Thank you very much sir 😊

[@gsuneel4679]

Please teach in English as well, so that other language people also understands, thank you.

[@shrushtiingle1711]

Can you please guide us if we want learn how to write medium to complex level queries with respect to logic how to break a query,how to understand what is expected and steps required for it please

[@pandu1730]

It's useful information.nice way of explanation.thank you bro.

[@CodingGlitz]

Thanks😃

[@EUK379]

very nice content i like it

[@CodingGlitz]

Thank you very much

[@santhoshkumar8143]

Thanks brother for your Valuable information

[@advitkothari7302]

helpful!! accelarate my preparation

[@smritisingha5152]

Really great video

[@CodingGlitz]

Thanks 🙂

[@sagarsharma007]

"BOHOT SAHI" --- ye umeed nahi kar raha tha intro ke liye ... jabarbast video mere bhai

[@CodingGlitz]

Thanks 😊

[@jagdish_soni3098]

Wow , your way off teaching 👏.

[@CodingGlitz]

Thank you! 😃

[@santoshsonihzb]

select concat(ename||' ', job) from emp; -- this is also run for concate with blank sapace

[@CodingGlitz]

You can use multiple pipes to concat instead of using the concat keyword (unless not asked specifically to use Concat keyword)

[@waheguru-gh7ps]

you are doing great job !

[@MuhammadUmairShaykh]

Gr8

[@ghanshyam014]

All the best for your upcoming episodes 😊

[@CodingGlitz]

Thanks a lot🙏

[@user-bv6il2nk4t]

top 50+30 pure dono vedio mean existing vedio jod ke one vedio bana do , ok and isme bas window function cte and thode complex sql add krwa do ok example bhai ankit bansal playlist

[@cheerladinnemouli2864]

Awesome it's really helpful for my placements 🙏🙏 tqqs a lot

[@CodingGlitz]

All d best.

[@cheerladinnemouli2864]

@@CodingGlitz tq sir

[@laxmanreddy2051]

please make videos in english next time tq for helping us

[@laxmanreddy2051]

Please provide any scenario based interview questions like ...sales data base. E com. Health care

[@shraddhadhakad1154]

Your way of explanation the concept is awesome. Btw i have a question - are you a Indori ? 😅😅

[@CodingGlitz]

Thanks . I am from Rourkela (Odisha).

[@TheKamakshya]

really good content thanks so much!

[@magantianusha5746]

i got 67 marks in this quiz.tq u so much for this it is very usefull to me.

[@CodingGlitz]

Great 👍

[@nehaprasad6665]

Best dialogue so far in this video.. Aur yha aap reject ho jaoge 😂😂 Best video..easily explained all the concepts ♥️

[@CodingGlitz]

😊😊

[@Barishrima]

Very helpful, thank you🙏

[@pushpitaroy7607]

You're awesome!!!

[@CodingGlitz]

Thanks 😊

[@singhisking639]

best video ever bro. Thanks a lot for your effort

[@CodingGlitz]

Thanks bro.. Please do like and share😊

[@saurabhsonawane9025]

Sirr joo..... Plz make vedio for top asked pl sql query 🙏🏻🙏🏻🙏🏻

[@travelkare]

Thanks!

[@kongaratenikar2098]

nice explanation ;)

[@user-ml7bq9wt3g]

thankyou so much sir

[@MayankSinghParmar]

In the 3rd question the alternative for 'between clause' should not be 'greater than' and 'less than', it should be 'greater than or equal to' and 'less than or equal to'

[@CodingGlitz]

Thanks, Correct, by mistake I have mentioned greater than and less than.

[@SkAlhtar]

great content brother, it helps me a lot.............only I can say thank u.

[@CodingGlitz]

Great to hear it helped you.. All the best .🙂

[@MohdMuddasser]

Nice explanation... You gained a subscriber...keep up the good work..

[@CodingGlitz]

Thanks 😊

[@raginishrivastav4264]

Great content.. 🙌 thanks for the video 👍

[@CodingGlitz]

Check description. Need to make slight changes in syntax as per MySQL.

[@raginishrivastav4264]

​@@CodingGlitzyes got it. Thank you 😊

[@z900_Guy]

You are a saviour ♥️♥️

[@ashokkumar-bs8ne]

Thankyou so much brother for such a wonderful content you have explained it in a very easy way❤

[@CodingGlitz]

Glad you liked it

[@nakulanand2725]

Very well explained sir thanks😊

[@anamikapatel4418]

for 5th question we can also use select first_name + ' '+ last_name from Table_Name;

[@CodingGlitz]

In SQL server

[@shubhamdeshmane6718]

Really helpful.. thank you so much sir..I want learn sql joins where I can learn all of that..

[@CodingGlitz]

Glat you liked this video. Checkout the below video for joins. kzbin.info/www/bejne/n6S0aaimYt-Ihrs Subquery:kzbin.info/www/bejne/e4LFmX6gd9KKbpo Also checkout other playlists which will be helpful for you.

[@shanukatiyar2742]

you cleared my many doubts and concepts thanks bro !!!

[@CodingGlitz]

Glad to know that🙂

[@vaishnvimane369]

Please bring more such videos of sql queries

[@CodingGlitz]

Sure 😊

[@RupeshKumar-tp7nw]

Maja aa gaya thx

[@deepjyotiray2010]

bhai bhai ! Bhot late mila apka channel ! itne pyar se kon padhata hai yar

[@CodingGlitz]

Thanks Bhai. 😊

[@BipinSingh-cu5jj]

Sir between use krne pe given value output aata hai but ap between ke jagah greater than or less tha ka use and operator sath ise toh given value nhi ayega

[@CodingGlitz]

Correct

[@Apna_tahlka_123]

Plj aaap excel k questions bhi lae aise hi practice k liye jldi se

[@Aysh_Sach_16-2]

bro OS ke liye bhi banado

[@srishtibhat6532]

Can you please tell suppose there is name like rohit and you need to display h and t how towrite a query forthat.Select SUBSTRING(3,5, 'ROHIT'); that will get characters at position 3,4,5 ut not only at 3,5.Can you help

[@CodingGlitz]

Please checkout this video and let me know if you still have any doubt. kzbin.info/www/bejne/Y4CQXn6Ir9SVl9U You can use 2 substrings and then concatenate.

[@nitinkumar-xw1vg]

Bhai aap interview bhi lete ho kya.for SQl. Kch latest quesy answers please share kr do. Mera interview hai wipro me

[@CodingGlitz]

No

[@nitinkumar-xw1vg]

So, kindly share some important and latest questions which is asked in interview for SQl .

[@beingrishi6450]

5:30 Can we update more than 1 condition in UPDATE clause?? Likewise UPDATE EMPLOYEE SET Salary = 64000 and ManagerId = 4 WHERE empID = 5???

[@biswajitsingh7501]

can we have this tables..so that we can pratice on it..

[@beingcheercool]

15:00

[@ombhalerao21]

Sir can we use LIMIT=1 without using HAVING clause?

[@CodingGlitz]

Having aur limit ka use bilkul alag hai. So I assume we cannot use.

[@intradaytrend8422]

70/100

[@vijendrabijalwan7936]

sir question 23 may apne 2 table ki join kiya hai ya only employee table hi liya hai

[@CodingGlitz]

kzbin.info/www/bejne/h2rFeoJ4mdhjotE Ye wala video dekho detail me explain Kiya gaya h

[@bhuv16]

Thank you... Going to watch all your SQL Plsql videos...Thanks and keep making videos.

[@vaibhavsingh1538]

Solutions start from 4:48 minute

[@CodingGlitz]

If anyone wants to check solution to any particular question directly click on timestamp given in description.

[@beingrishi6450]

9:33 Im getting 0 in each records in the output

[@vikkynarepagul256]

Select * from employee order by salary DESC LIMIT 3

[@CodingGlitz]

In MySQL

[@hhcdghjjgsdrt235]

38:00

[@showbizstyle9572]

how can we practice? can you share dummy data

[@hemantkshirsagar]

I am using workbench. While i was practicing 3rd highest salary question im not getting row_num keyword? how to solve this.

[@CodingGlitz]

It will work in Oracle SQL which SQL are you using?? You can use limit in MySQL and top keyword in case of SQL Server

[@leoking2386]

Can you tell how can we do Q24 in MySQL?

[@mindblowingtinku8126]

Sir for the last question wherein we are finding nth highest salary , if the table is huge it will be taking time to fetch the sollution, alternate answer for same select * FROM ( select *, DENSE_RANK() over(order by Base_Salary Desc) rnk from employee_salaries ) emp where emp.rnk=5;

[@CodingGlitz]

Yes correct... Thanks🙂 We have discussed different approaches for this problem in a separate video kzbin.info/www/bejne/oqHLpaR8j5Kch8U

[@user-mo2gu1wo6p]

why datatype like varchar2, Number8 is not accepted by sql server...Its simply accepting INT or VARCHAR due to this I am not able to create the sample data....what is the solution ?

[@CodingGlitz]

www.w3schools.com/sql/sql_datatypes.asp

[@sharathcg4697]

For 7th question, NOT operator should be added,l as we need to exclude first names Anushka and somnath. Please check it

[@CodingGlitz]

Correct.. Typo please ignore already mentioned in comments.

[@I_am_smooth_as_butter]

Bhai code bhi daal dete insert karne ka..we don't have data to practice along with you

[@CodingGlitz]

Description me data hai

[@user-gl9lg3jc8o]

Tried que 23 as its but im not getting output. e1.salary in on clause

[@CodingGlitz]

Which db are you using??

[@vijendrabijalwan7936]

sir in questions ki pdf mil payegi

[@CookNitesh]

can you plz provide the pdf of answers and questions in this video???......it will be very helpfull for me....

[@CodingGlitz]

Hey Nitesh, Sorry actually my laptop got crashed and all the materials which I had prepared are lost. I will definitely share if able to recover. Also there is delay in uploading further videos because of that.

[@CookNitesh]

@@CodingGlitz ok fine.... but let me tell u ,your videos are quite helpful for me....especially the interview questions videos.....thnx....

[@darksoul0722]

There might have been a slight misunderstanding in question number 7 of the requirement to exclude employees with the first names "Anushka" and "Somnath." Your queries currently select those specific employees. To exclude these employees, the query should use the NOT IN clause. Here’s the correct version: SELECT * FROM employees WHERE first_name NOT IN ('Anushka', 'Somnath'); This query will return all employees except those whose first names are "Anushka" or "Somnath." I hope this helps

[@lilyfullery4779]

many of the functions are there which are not working like instr and mod function can u please tell me why its happening.

[@CodingGlitz]

I think you are using MySQL or any other database. Just you need to search for its alternative in the database you are working on. If you are still facing problem let me know we will find the root cause and solution.

[@iamamol429]

Last ka answer bhot lamba kiya using limit it's easy and used n-1 to get nth highest salary

[@beingrishi6450]

16:32 This is not working in MySQL as per query given in google drive form

[@sohelpathan7601]

Where to get tables for practicing all questions ..!

[@CodingGlitz]

docs.google.com/document/u/0/d/1Xv9xCNTGZm4SuAlR5hmzOoraq_Jc2YIZ/mobilebasic

[@mahesh1724]

Hi sir.. I completed M_Tech in Mechanical Engineering n worked as Assistant Professor since from last 10 year .. Now I want to switch into IT field as Fresher...NOW I am learning SQL ... Is there any chance getting job in IT industry after a such long gap.. please suggest me sir..

[@CodingGlitz]

Hi @mahesh I would suggest don't try as fresher and start from scratch. You can show 4-5 years of experience in IT with some realtime projects and just show them as your experience. There is a lot of scope and you can definitely try and get a job. And you can also explore SAP consultant job which might be suitable according to your background and experience. All the very best.

[@mahesh1724]

@@CodingGlitz THANK U SIR... PLEASE suggest how to make resume ..