SQL Interview Questions
前往频道在 Telegram
Channel for SQL learning: @sql_res Chennal for SQL syntax: @sql_syntax Chennal for SQL interview questions: @etl_sql_interview
显示更多未指定国家未指定类别
2 405
订阅者
无数据24 小时
-27 天
-1730 天
正在加载数据
吸引订阅者
十月 '2610月 '26
十月 '26
+179
在0个频道中
九月 '260
在0个频道中
Get PRO
八月 '260
在0个频道中
Get PRO
七月 '260
在0个频道中
Get PRO
六月 '260
在0个频道中
Get PRO
五月 '260
在0个频道中
Get PRO
四月 '260
在0个频道中
Get PRO
三月 '260
在0个频道中
Get PRO
二月 '260
在0个频道中
Get PRO
一月 '260
在0个频道中
Get PRO
十二月 '250
在0个频道中
Get PRO
十一月 '250
在0个频道中
Get PRO
十月 '250
在0个频道中
Get PRO
九月 '250
在0个频道中
Get PRO
八月 '250
在0个频道中
Get PRO
七月 '250
在0个频道中
Get PRO
六月 '250
在0个频道中
Get PRO
五月 '250
在0个频道中
Get PRO
四月 '250
在0个频道中
Get PRO
三月 '250
在0个频道中
Get PRO
二月 '250
在0个频道中
Get PRO
一月 '250
在0个频道中
Get PRO
十二月 '24
+76
在0个频道中
Get PRO
十一月 '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个频道中
| 日期 | 订阅者增长 | 提及 | 频道 | |
| 26 十月 | 0 | |||
| 25 十月 | +3 | |||
| 24 十月 | +1 | |||
| 23 十月 | 0 | |||
| 22 十月 | +1 | |||
| 21 十月 | 0 | |||
| 20 十月 | +3 | |||
| 19 十月 | 0 | |||
| 18 十月 | +2 | |||
| 17 十月 | +1 | |||
| 16 十月 | 0 | |||
| 15 十月 | +2 | |||
| 14 十月 | +1 | |||
| 13 十月 | +1 | |||
| 12 十月 | 0 | |||
| 11 十月 | +1 | |||
| 10 十月 | 0 | |||
| 09 十月 | +1 |
频道帖子
| 2 | 1. Answer : A. It transforms the
stored column values for every row before comparing them, preventing the query engine from navigating the pre-sorted B-Tree index structure using an index seek.
Reason: A condition is SARGable (Search Argument Able) only when the database engine can utilize an index seek directly on the raw column values stored in the B-Tree. Wrapping the column in a function alters its representation dynamically per row, necessitating a full index or table scan to compute the function value for each entry. | 462 |
| 3 | Sql Interview question:
1.
Why does applying a function like YEAR(order_date) on an indexed column inside a WHERE clause typically lead to a non-SARGable condition and a full table scan?
A. It transforms the stored column values for every row before comparing them, preventing the query engine from navigating the pre-sorted B-Tree index structure using an index seek.
B. It violates strict ACID normalization rules, causing the transaction log to lock the entire table instead of row-level locking.
C. It converts the data type from integer to varchar, triggering a catastrophic implicit conversion error that halts query execution.
D. It disables multi-threading capabilities, forcing the query optimizer to process records on a single CPU core sequentially. | 522 |
| 4 | https://t.me/AI_Agents_RAG_Learn/28
9 wonderful lectures for learning from Transformers to Agentic systems.
7th Lecture: Agentic LLMs
8th Lecture: LLM Evaluation, where most production teams need deep understanding. | 443 |
| 5 | Let's learn how to build Production graded Agentic AI in most effective way, roadmap, courses, links
https://t.me/AI_Agents_RAG_Learn | 511 |
| 6 | Leetcode SQL
Bit faster explanation
https://youtube.com/playlist?list=PLdrw9_aIADIPAMJW8I_S-S747oyiRtzpS
Detailed Explanation
https://youtube.com/playlist?list=PLtfxzVLWb-B-O3VAjxsoZYgG6d8WMnPjG | 280 |
| 7 | SQL interview queries - BIG 4
https://youtu.be/dWHSt0BVlv0 | 196 |
| 8 | Tricky SQL interview questions
https://youtu.be/aE623ff7zkM | 236 |
| 9 | 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 |
| 10 | Top 10 SQL interview queries for experienced
https://youtu.be/zvuWEysWoLE | 252 |
| 11 | Top 25 SQL interview Questions and Answers
https://youtu.be/AK7_m-aThfw | 0 |
| 12 | 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 | 0 |
| 13 | MySQL Commands: Full List With Examples
https://www.interviewbit.com/blog/mysql-commands/?amp=1 | 0 |
| 14 | Top 25 SQL interview Questions
https://youtu.be/AK7_m-aThfw | 697 |
| 15 | https://www.kdnuggets.com/2020/11/5-tricky-sql-queries-solved.html | 865 |
| 16 | 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 |
| 17 | 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 |
| 18 | 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 |
| 19 | 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 |
| 20 | Most commonly asked SQL interview questions
https://youtu.be/L-URbfgxBMQ | 592 |
