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: https://drive.google.com/file/d/1bXUx...

Try and attempt Multiple Choice Questions below and do comment if you like the MCQ:
https://forms.gle/4NHaRjoqFbYrgqrg9
Check out Solutions:    • SQL MCQ Questions & Answers  

Subscribe the Channel to keep watching interesting videos helpful for your career growth:

   / @codingglitz  

--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

Checkout different playlists:

PLSQL Tutorial :    • PLSQL Tutorial || PL SQL tutorial for...  
Learn DBMS & SQL :    • SQL Tutorial for Beginners || SQL Pla...  
SQL Interview Questions and answers:    • sql interview questions and answers i...  
Interview Tips :    • Interview Tips  

--------------------------------------------------
--------------------------------------------------

Checkout Important videos :

Top 30 SQL Queries Interview Questions and Answers :    • SQL Queries Interview Questions and a...  
Top 50 SQL Concepts Interview Questions and Answers :    • SQL Interview Questions And Answers  
SQL JOINS :    • SQL Joins With Examples | SQL Joins T...  
SUB QUERY :    • Subquery in SQL || SQL Subquery tutor...  
Employee earning maximum salary in each department query :    • SQL Query to find Employee with maxim...  
How to find Nth highest salary (3 different solutions):    • SQL query to find Nth Highest salary ...  
Tricky SQL Queries Part1 :    • SQL Tricky and Important Interview Qu...  
AGGREGATE FUNCTION:    • Aggregate function  || SQL Tutorial f...  
GROUP BY :    • GROUP BY  & HAVING || SQL Tutorial fo...  


How to practice SQL Queries in local / Install Database in local :    • How to Install Oracle Database (19C) ...  
IT Jobs without Coding :    • IT Jobs without coding with high sala...  

-----------------------------------------------------------------------------
-----------------------------------------------------------------------------

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