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 روز
در حال بارگذاری داده‌ها
کانال‌های مشابه
ابر برچسب‌ها
هیچ داده‌ای
مشکلی وجود دارد؟ لطفاً صفحه را تازه کنید یا با مدیر پشتیبانی ما تماس بگیرید.
اشارات ورودی و خروجی
---
---
---
---
---
---
جذب مشترکین
اکتبر '26اکتبر '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 |
