Рет қаралды 203,453
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