Firibgarlarga uchmang! Telemetrio bunday kanallarni topadi va belgilaydi 👉 Belgini ko‘rmoqchi bo‘lsangiz, obuna bo‘ling

SQL Interview Questions

Kanalga Telegram’da o‘tish

Channel for SQL learning: @sql_res Chennal for SQL syntax: @sql_syntax Chennal for SQL interview questions: @etl_sql_interview

Ko'proq ko'rsatish

Mamlakat belgilanmaganToif belgilanmagan

2 405

Obunachilar

Ma'lumot yo'q24 soatlar

-27 kun

-1730 kun

468

Post ko'rishlar

~ 13724 soatlar

~ 18348 soatlar

19.44%

Muloqot nisbati

Ma'lumot yo'q

Kuniga postlar

Ads index

beta

Ma'lumotlar yuklanmoqda

O'xshash kanallar

8.5K

JASA TERBAIK PINJOL GALBAY

7.9K

Data Engineering & AI | Apache Spark

5.9K

Oracle sql plsql questions

5.9K

Coding Interview Preparation

5.8K

Ms SQL Server

Ko'proq kanallar

Taglar buluti

Ma'lumot yo'q

Muammo bormi? Iltimos, sahifani yangilang yoki bizning qo'llab-quvvatlash boshqaruvchimizga murojaat qiling>.

Kirish va chiqish esdaliklari

---

Obunachilarni jalb qilish

Oktabr '26Okt '26

Oktabr '26

+179

0 kanalda

Sentabr '260

0 kanalda

Get PRO

Avgust '260

0 kanalda

Get PRO

Iyul '260

0 kanalda

Get PRO

Iyun '260

0 kanalda

Get PRO

May '260

0 kanalda

Get PRO

Aprel '260

0 kanalda

Get PRO

Mart '260

0 kanalda

Get PRO

Fevral '260

0 kanalda

Get PRO

Yanvar '260

0 kanalda

Get PRO

Dekabr '250

0 kanalda

Get PRO

Noyabr '250

0 kanalda

Get PRO

Oktabr '250

0 kanalda

Get PRO

Sentabr '250

0 kanalda

Get PRO

Avgust '250

0 kanalda

Get PRO

Iyul '250

0 kanalda

Get PRO

Iyun '250

0 kanalda

Get PRO

May '250

0 kanalda

Get PRO

Aprel '250

0 kanalda

Get PRO

Mart '250

0 kanalda

Get PRO

Fevral '250

0 kanalda

Get PRO

Yanvar '250

0 kanalda

Get PRO

Dekabr '24

+76

0 kanalda

Get PRO

Noyabr '24

+58

0 kanalda

Get PRO

Oktabr '24

+76

0 kanalda

Get PRO

Sentabr '24

+86

0 kanalda

Get PRO

Avgust '24

+365

0 kanalda

Get PRO

Iyul '240

0 kanalda

Get PRO

Iyun '240

0 kanalda

Get PRO

May '240

0 kanalda

Get PRO

Aprel '240

0 kanalda

Get PRO

Mart '24

+35

0 kanalda

Get PRO

Fevral '24

+634

0 kanalda

Get PRO

Yanvar '240

0 kanalda

Get PRO

Dekabr '230

0 kanalda

Get PRO

Noyabr '230

0 kanalda

Get PRO

Oktabr '230

0 kanalda

Get PRO

Sentabr '230

0 kanalda

Get PRO

Avgust '230

0 kanalda

Get PRO

Iyul '230

0 kanalda

Get PRO

Iyun '230

0 kanalda

Get PRO

May '230

0 kanalda

Get PRO

Aprel '230

0 kanalda

Get PRO

Mart '23

+107

0 kanalda

Get PRO

Fevral '23

+135

0 kanalda

Get PRO

Yanvar '23

+121

0 kanalda

Get PRO

Dekabr '22

+60

0 kanalda

Get PRO

Noyabr '22

+61

0 kanalda

Get PRO

Oktabr '22

+52

0 kanalda

Get PRO

Sentabr '22

+67

0 kanalda

Get PRO

Avgust '22

+139

0 kanalda

Get PRO

Iyul '22

+258

0 kanalda

Sana	Obunachilarni jalb qilish	Esdaliklar	Kanallar
26 Oktabr	0
25 Oktabr	+3
24 Oktabr	+1
23 Oktabr	0
22 Oktabr	+1
21 Oktabr	0
20 Oktabr	+3
19 Oktabr	0
18 Oktabr	+2
17 Oktabr	+1
16 Oktabr	0
15 Oktabr	+2
14 Oktabr	+1
13 Oktabr	+1
12 Oktabr	0
11 Oktabr	+1
10 Oktabr	0
09 Oktabr	+1

Kanal postlari

https://t.me/AI_Agents_RAG_Learn/35

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

Barcha postlarni ko‘rish