SQL Tutorial for Beginners || SQL Playlist Hindi

Currently Playing: 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/1bXUxWsSu_59mT56tbyDLz_ofvdYCZNq7/view?usp=share_link Try and attempt Multiple Choice Questions below and do comment if you like the MCQ: https://forms.gle/4NHaRjoqFbYrgqrg9 Check out Solutions: https://youtu.be/sV0swTnWc2I Subscribe the Channel to keep watching interesting videos helpful for your career growth: https://youtube.com/channel/UCaoCTb7FoUYOo9R8r_X9YHg?sub_confirmation=1 -------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------- Checkout different playlists: PLSQL Tutorial : https://youtube.com/playlist?list=PLKVxK2jv1oA-LwzbMlOFZS-CgbucH5OhQ Learn SQL for Beginners : https://www.youtube.com/playlist?list=PLKVxK2jv1oA9Ow28rg__JaBWjJQtoPyu6 SQL Interview Questions and answers: https://www.youtube.com/playlist?list=PLKVxK2jv1oA_t7KqNfdUgNC9x54vymFbb Interview Tips : https://www.youtube.com/playlist?list=PLKVxK2jv1oA-_-h-qPt1RiI926j9VxFYa -------------------------------------------------- -------------------------------------------------- Checkout Important videos : Learn SQL in 30 mins: https://youtu.be/cQCQXCW2qwA Top 30 SQL Queries Interview Questions and Answers : https://youtu.be/sa6_kqlglLs Top 50 SQL Concepts Interview Questions and Answers : https://youtu.be/UZAqMAzCZss SQL JOINS : https://youtu.be/isQ8up-zUPY SUB QUERY : https://youtu.be/EQbhKjBmW88 Employee earning maximum salary in each department query : https://youtu.be/Q9bIOBds0lo How to find Nth highest salary (3 different solutions): https://youtu.be/lphtqFZ-iQc Tricky SQL Queries Part1 : https://youtu.be/-JwSWMm0E40 AGGREGATE FUNCTION: https://youtu.be/SpvTUjPfV20 GROUP BY : https://youtu.be/tF_SU_5QXuU How to practice SQL Queries in local / Install Database in local : https://youtu.be/2RLyGa9dr8A IT Jobs without Coding : https://youtu.be/zTHRaNRxtXc ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- 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