SQL GATE17 Nested Query Subquery in the WHERE Clause

preview_player
Показать описание
IMPORTANT LINKS:
Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share!

Our Social Media Links:

Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
  1. Edredo for Learners
  2. GATE
  3. IIT
  4. Techtud
  5. Engineering
  6. DBMS
Рекомендации по теме
SQL GATE17 Nested 0:03:47

SQL GATE17 Nested Query Subquery in the WHERE Clause

SQL - How 0:20:27

SQL - How To Use Subqueries in the WHERE Clause (with 2 Examples)

# 31 - 0:53:57

# 31 - SQL - Nested Sub-queries - 2

SQL for Beginners 0:03:36

SQL for Beginners 150 SUBQUERY IN THE WHERE CLAUSE

45 Scalar 0:05:17

45 Scalar Subqueries Microsoft SQL Server

SQL Identifying Repeated 0:06:40

SQL Identifying Repeated Rows using GROUP BY and HAVING

SQL GATE16 WITH 0:05:36

SQL GATE16 WITH Clause

RA GATE17 Division 0:09:02

RA GATE17 Division Select Project Operators

Fundamentals Of Subqueries, 0:19:37

Fundamentals Of Subqueries, Single-Row Subqueries, Multiple-Row Subqueries & Correlated Subqueri...

SQL GATE15 Natural 0:06:43

SQL GATE15 Natural Join with FROM and WHERE Clause

Number of tuples 0:13:55

Number of tuples Returned SQL query || Previous Years Questions Solved

Illustration on Set 0:10:55

Illustration on Set Comparison Operator

Комментарии
Автор

i've got an error when run this query
select avg(ec.num)
from ec
where (deptname, num) IN
(
select deptname, count(empid) as ec(deptname, num)
from emp
group by deptname
)

palisnt
Автор

পড়াশুনার চাপে আমার লেখাপড়া নষ্ট হয়ে গেলো 😂😂

ashismohanta