SQL Interview Questions
Открыть в Telegram
Channel for SQL learning: @sql_res Chennal for SQL syntax: @sql_syntax Chennal for SQL interview questions: @etl_sql_interview
БольшеСтрана не указанаКатегория не указана
952
Подписчики
+124 часа
+97 дней
+7730 дней
Загрузка данных...
Облако тегов
Нет данных
Возникли проблемы? Пожалуйста, обновите страницу или обратитесь к нашему support-менеджеру .
Входящие и исходящие упоминания
---
---
---
---
---
---
Привлечение подписчиков
декабрь '24
декабрь '24
+76
в 0 каналах
ноябрь '24
+58
в 0 каналах
Get PRO
октябрь '24
+76
в 0 каналах
Get PRO
сентябрь '24
+86
в 0 каналах
Get PRO
август '24
+365
в 0 каналах
Get PRO
июль '240
в 0 каналах
Get PRO
июнь '240
в 0 каналах
Get PRO
май '240
в 0 каналах
Get PRO
апрель '240
в 0 каналах
Get PRO
март '24
+35
в 0 каналах
Get PRO
февраль '24
+634
в 0 каналах
Get PRO
январь '240
в 0 каналах
Get PRO
декабрь '230
в 0 каналах
Get PRO
ноябрь '230
в 0 каналах
Get PRO
октябрь '230
в 0 каналах
Get PRO
сентябрь '230
в 0 каналах
Get PRO
август '230
в 0 каналах
Get PRO
июль '230
в 0 каналах
Get PRO
июнь '230
в 0 каналах
Get PRO
май '230
в 0 каналах
Get PRO
апрель '230
в 0 каналах
Get PRO
март '23
+107
в 0 каналах
Get PRO
февраль '23
+135
в 0 каналах
Get PRO
январь '23
+121
в 0 каналах
Get PRO
декабрь '22
+60
в 0 каналах
Get PRO
ноябрь '22
+61
в 0 каналах
Get PRO
октябрь '22
+52
в 0 каналах
Get PRO
сентябрь '22
+67
в 0 каналах
Get PRO
август '22
+139
в 0 каналах
Get PRO
июль '22
+258
в 0 каналах
| Дата | Привлечение подписчиков | Упоминания | Каналы | |
| 21 декабря | +5 | |||
| 20 декабря | +2 | |||
| 19 декабря | +4 | |||
| 18 декабря | +9 | |||
| 17 декабря | +9 | |||
| 16 декабря | +4 | |||
| 15 декабря | 0 | |||
| 14 декабря | +3 | |||
| 13 декабря | +1 | |||
| 12 декабря | +11 | |||
| 11 декабря | +1 | |||
| 10 декабря | +3 | |||
| 09 декабря | +2 | |||
| 08 декабря | +3 | |||
| 07 декабря | +5 | |||
| 06 декабря | +1 | |||
| 05 декабря | +4 | |||
| 04 декабря | +1 | |||
| 03 декабря | +3 | |||
| 02 декабря | +3 | |||
| 01 декабря | +2 |
Посты канала
Leetcode SQL
Bit faster explanation
https://youtube.com/playlist?list=PLdrw9_aIADIPAMJW8I_S-S747oyiRtzpS
Detailed Explanation
https://youtube.com/playlist?list=PLtfxzVLWb-B-O3VAjxsoZYgG6d8WMnPjG
| 2 | SQL interview queries - BIG 4
https://youtu.be/dWHSt0BVlv0 | 196 |
| 3 | Tricky SQL interview questions
https://youtu.be/aE623ff7zkM | 236 |
| 4 | 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 | 518 |
| 5 | Top 10 SQL interview queries for experienced
https://youtu.be/zvuWEysWoLE | 252 |
| 6 | Top 25 SQL interview Questions
https://youtu.be/AK7_m-aThfw | 697 |
| 7 | https://www.kdnuggets.com/2020/11/5-tricky-sql-queries-solved.html | 865 |
| 8 | 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; | 915 |
| 9 | 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. | 853 |
| 10 | 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; | 745 |
| 11 | 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. | 609 |
| 12 | Most commonly asked SQL interview questions
https://youtu.be/L-URbfgxBMQ | 592 |
| 13 | 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; | 620 |
| 14 | 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. | 564 |
| 15 | 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 ) | 528 |
| 16 | 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; | 554 |
| 17 | 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. | 526 |
| 18 | Click below link to Refer three Tables here for writing queries👇
https://t.me/etl_sql_interview/8
Q-21. Write an SQL query to fetch the count of employees working in the department ‘Admin’.
Q-22. Write an SQL query to fetch worker names with salaries >= 50000 and <= 100000.
Q-23. Write an SQL query to fetch the no. of workers for each department in the descending order.
Q-24. Write an SQL query to print details of the Workers who are also Managers.
Q-25. Write an SQL query to fetch duplicate records having matching data in some fields of a table.
For Answers 🤔 click here 👇
https://t.me/etl_sql_interview/32 | 549 |
| 19 | Click below link to Refer three Tables here for writing queries👇
https://t.me/etl_sql_interview/8
Answer:
1. Select FIRST_NAME AS WORKER_NAME from Worker;
2. Select upper(FIRST_NAME) from Worker;
3. Select distinct DEPARTMENT from Worker;
4. Select substring(FIRST_NAME,1,3) from Worker;
5.Select INSTR(FIRST_NAME, BINARY'a') from Worker where FIRST_NAME = 'Amitabh';
6.Select RTRIM(FIRST_NAME) from Worker;
7.Select LTRIM(DEPARTMENT) from Worker;
8.Select distinct length(DEPARTMENT) from Worker;
9.Select REPLACE(FIRST_NAME,'a','A') from Worker;
10.Select CONCAT(FIRST_NAME, ' ', LAST_NAME) AS 'COMPLETE_NAME' from Worker;
11.Select * from Worker order by FIRST_NAME asc;
12.Select * from Worker order by FIRST_NAME asc,DEPARTMENT desc;
13.Select * from Worker where FIRST_NAME in ('Vipul','Satish');
14.Select * from Worker where FIRST_NAME not in ('Vipul','Satish');
15. Select * from Worker where DEPARTMENT like 'Admin%';
16. Select * from Worker where FIRST_NAME like '%a%';
17. Select * from Worker where FIRST_NAME like '%i';
18. Select * from Worker where FIRST_NAME like '_h';
19. Select * from Worker where SALARY between 100000 and 500000;
20.Select * from Worker where year(JOINING_DATE) = 2014 and month(JOINING_DATE) = 2;
21. SELECT COUNT(*) FROM worker WHERE DEPARTMENT = 'Admin';
22. SELECT CONCAT(FIRST_NAME, ' ', LAST_NAME) As Worker_Name, Salary
FROM worker
WHERE WORKER_ID IN
(SELECT WORKER_ID FROM worker
WHERE Salary BETWEEN 50000 AND 100000);
23. SELECT DEPARTMENT, count(WORKER_ID) No_Of_Workers
FROM worker
GROUP BY DEPARTMENT
ORDER BY No_Of_Workers DESC;
24. SELECT DISTINCT W.FIRST_NAME, T.WORKER_TITLE
FROM Worker W
INNER JOIN Title T
ON W.WORKER_ID = T.WORKER_REF_ID
AND T.WORKER_TITLE in ('Manager');
25. SELECT WORKER_TITLE, AFFECTED_FROM, COUNT(*)
FROM Title
GROUP BY WORKER_TITLE, AFFECTED_FROM
HAVING COUNT(*) > 1; | 537 |
