ar
Feedback
SQL Interview Questions

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 أيام

جاري تحميل البيانات...

القنوات المماثلة
Oracle sql plsql questions
5.9K
Oracle sql plsql questions
Learn Data with Satyajit Pattnaik
1.8K
Learn Data with Satyajit Pattnaik
سحابة العلامات
لا توجد بيانات
هل تواجه مشاكل؟ يرجى تحديث الصفحة أو الاتصال بمدير الدعم الخاص بنا.
الإشارات الواردة والصادرة
---
---
---
---
---
---
جذب المشتركين
ديسمبر '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
منشورات القناة
SQL Interview Questions

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 and Answers https://youtu.be/AK7_m-aThfw
0
7
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
8
MySQL Commands: Full List With Examples https://www.interviewbit.com/blog/mysql-commands/?amp=1
0
9
Top 25 SQL interview Questions https://youtu.be/AK7_m-aThfw
697
10
https://www.kdnuggets.com/2020/11/5-tricky-sql-queries-solved.html
865
11
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
12
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
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/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
14
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
15
Most commonly asked SQL interview questions https://youtu.be/L-URbfgxBMQ
592
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/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
17
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
18
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
19
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
20
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
عرض جميع المنشورات