SQL Interview Questions

Leetcode SQL Bit faster explanation https://youtube.com/playlist?list=PLdrw9_aIADIPAMJW8I_S-S747oyiRtzpS Detailed Explanation https://youtube.com/playlist?list=PLtfxzVLWb-B-O3VAjxsoZYgG6d8WMnPjG

SQL interview queries - BIG 4 https://youtu.be/dWHSt0BVlv0

Tricky SQL interview questions https://youtu.be/aE623ff7zkM

Commonly asked questions - Difference between concepts which looks similar but they aren't ( eg: where vs having, Exists vs In.. etc ) Part 1 : https://youtu.be/RZc4QSRRk98 Part 2 : https://youtu.be/s1QkS4PfiFg

Top 10 SQL interview queries for experienced https://youtu.be/zvuWEysWoLE

Top 25 SQL interview Questions and Answers https://youtu.be/AK7_m-aThfw

SQL Interview Questions Basic Level : https://intellipaat.com/blog/interview-question/sql-interview-questions/#11 Intermediate Level : https://intellipaat.com/blog/interview-question/sql-interview-questions/#12 Advance Level : https://intellipaat.com/blog/interview-question/sql-interview-questions/#13

MySQL Commands: Full List With Examples https://www.interviewbit.com/blog/mysql-commands/?amp=1

Top 25 SQL interview Questions https://youtu.be/AK7_m-aThfw

To Refer three tables for writing queries👇 https://t.me/etl_sql_interview/8 To Refer questions for writing queries👇 https://t.me/etl_sql_interview/43 Answers : 41. SELECT DEPARTMENT, COUNT(DEPARTMENT) as 'Number of Workers' FROM Worker GROUP BY DEPARTMENT; 42. Select * from Worker where WORKER_ID = (SELECT max(WORKER_ID) from Worker); 43. Select * from Worker where WORKER_ID = (SELECT min(WORKER_ID) from Worker); 44. SELECT * FROM Worker WHERE WORKER_ID <=5 UNION SELECT * FROM (SELECT * FROM Worker W order by W.WORKER_ID DESC) AS W1 WHERE W1.WORKER_ID <=5; 45. SELECT t.DEPARTMENT,t.FIRST_NAME,t.Salary from(SELECT max(Salary) as TotalSalary,DEPARTMENT from Worker group by DEPARTMENT) as TempNew Inner Join Worker t on TempNew.DEPARTMENT=t.DEPARTMENT and TempNew.TotalSalary=t.Salary;

Click below link to Refer three tables here for writing queries 👇 https://t.me/etl_sql_interview/8 Q-41. Write an SQL query to show all departments along with the number of people in there. Q-42. Write an SQL query to show the last record from a table. Q-43. Write an SQL query to fetch the first row of a table. Q-44. Write an SQL query to fetch the last five records from a table. Q-45. Write an SQL query to print the name of employees having the highest salary in each department.

To Refer three tables for writing queries👇 https://t.me/etl_sql_interview/8 To Refer questions for writing queries👇 https://t.me/etl_sql_interview/41 Answers : 36. Select max(Salary) from Worker where Salary not in (Select max(Salary) from Worker); 37. select FIRST_NAME, DEPARTMENT from worker W where W.DEPARTMENT='HR' union all select FIRST_NAME, DEPARTMENT from Worker W1 where W1.DEPARTMENT='HR'; 38. (SELECT * FROM Worker) INTERSECT (SELECT * FROM WorkerClone); 39.SELECT * FROM WORKER WHERE WORKER_ID <= (SELECT count(WORKER_ID)/2 from Worker); 40. SELECT DEPARTMENT, COUNT(WORKER_ID) as 'Number of Workers' FROM Worker GROUP BY DEPARTMENT HAVING COUNT(WORKER_ID) < 5;

Click below link to Refer three tables here for writing queries 👇 https://t.me/etl_sql_interview/8 Q-36. Write an SQL query to show the second highest salary from a table. Q-37. Write an SQL query to show one row twice in results from a table. Q-38. Write an SQL query to fetch intersecting records of two tables. Q-39. Write an SQL query to fetch the first 50% records from a table. Q-40. Write an SQL query to fetch the departments that have less than five people in it.

Most commonly asked SQL interview questions https://youtu.be/L-URbfgxBMQ

To Refer three tables for writing queries👇 https://t.me/etl_sql_interview/8 To Refer questions for writing queries👇 https://t.me/etl_sql_interview/37 Answers : 31. SELECT SYSDATE FROM DUAL; 32. SELECT * FROM (SELECT * FROM Worker ORDER BY Salary DESC) WHERE ROWNUM <= 10; 33. SELECT Salary FROM Worker ORDER BY Salary DESC LIMIT n-1,1; 34. SELECT Salary FROM Worker W1 WHERE 4 = ( SELECT COUNT( DISTINCT ( W2.Salary ) ) FROM Worker W2 WHERE W2.Salary >= W1.Salary ); 35. Select distinct W.WORKER_ID, W.FIRST_NAME, W.Salary from Worker W, Worker W1 where W.Salary = W1.Salary and W.WORKER_ID != W1.WORKER_ID;

Click below link to Refer three tables here for writing queries 👇 https://t.me/etl_sql_interview/8 Q-31. Write an SQL query to show the current date and time. Q-32. Write an SQL query to show the top n (say 10) records of a table. Q-33. Write an SQL query to determine the nth (say n=5) highest salary from a table. Q-34. Write an SQL query to determine the 5th highest salary without using TOP or limit method. Q-35. Write an SQL query to fetch the list of employees with the same salary.

covers many interesting interview questions checkout This playlist 👇 https://youtube.com/playlist?list=PLdrw9_aIADIPAMJW8I_S-S747oyiRtzpS Tip: Try to do just one per day ( If possible two/day on weekends )

Click below links To Refer three tables for writing queries👇 https://t.me/etl_sql_interview/8 To Refer questions for writing queries👇 https://t.me/etl_sql_interview/34 Answers: 26. SELECT * FROM Worker WHERE MOD (WORKER_ID, 2) <> 0; 27. SELECT * FROM Worker WHERE MOD (WORKER_ID, 2) = 0; 28. SELECT * INTO WorkerClone FROM Worker; 29. (SELECT * FROM Worker) INTERSECT (SELECT * FROM WorkerClone); 30. SELECT * FROM Worker MINUS SELECT * FROM Title;

Click below link to Refer three tables here for writing queries👇 https://t.me/etl_sql_interview/8 Q-26. Write an SQL query to show only odd rows from a table. Q-27. Write an SQL query to show only even rows from a table. Q-28. Write an SQL query to clone a new table from another table. Q-29. Write an SQL query to fetch intersecting records of two tables. Q-30. Write an SQL query to show records from one table that another table does not have.