Aliens School
Cinematic Knowledge Experience
0%
Aliens School
Now Playing
Aliens School ยท HIEN
โŒจ๏ธ Keyboard Shortcuts
โ†’Next slide โ†Previous slide SpacePlay / Pause MNarration on/off FFullscreen ?Show/hide this
Press any key to close
Skill Topic ยท Cinematic

๐Ÿ“˜ SQL HAVING - Groups Ko Filter Karna

HAVING clause se tum GROUP BY ke results ko filter kar sakte ho โ€” jaise sirf woh countries dikhaoโ€ฆ

Overview
๐ŸŒŸ

๐Ÿ“˜ SQL HAVING - Groups Ko Filter Karna โ€” Quick Facts

๐Ÿ“Œ

OrderID: CustomerID

๐ŸŽฏ

101: 1

โšก

102: 2

๐Ÿ”‘

103: 3

Topic 1
โœจ

๐Ÿ“Œ HAVING Kya Hai?

๐Ÿ“š HAVING clause GROUP BY ke baad groups ko filter karta hai. WHERE individual rows filterโ€ฆ
Topic 2
๐Ÿ’ก ๐Ÿ“Š ๐Ÿ”ฌ

๐Ÿ“Œ HAVING Syntax

๐Ÿ’ก `sql SELECT column(s), aggregate_function(column) FROM table_name WHERE condition -- rowsโ€ฆ
Topic 3
๐Ÿ“ฅ ๐Ÿ“ฅ ๐Ÿง  ๐Ÿ”ฌ ๐Ÿ’ก ๐ŸŽฏ

๐Ÿ“Œ Demo Database

๐ŸŽฏ Orders: | OrderID | CustomerID | Country | Amount | OrderDate |โ€ฆ
Topic 4
โญ

๐Ÿ“Œ Basic HAVING โ€” COUNT Filter

โญ `sql -- Sirf woh countries jinke 2 se zyada orders hain SELECT Country, COUNT(*) ASโ€ฆ
Topic 5
๐Ÿ“ฅ ๐Ÿ“ฅ ๐Ÿง  ๐Ÿ”ฌ ๐Ÿ’ก ๐ŸŽฏ

๐Ÿ“Œ HAVING With SUM

๐Ÿ”‘ `sql -- Countries jinki total revenue 10000 se zyada hai SELECT Country, COUNT(*) ASโ€ฆ
Topic 6
โœจ ๐Ÿ“Š ๐Ÿ”ฌ

๐Ÿ“Œ HAVING With AVG

โœจ `sql -- Countries jinka average order value 5000 se zyada hai SELECT Country, COUNT(*) ASโ€ฆ
Topic 7
๐Ÿ“ฅ โš™๏ธ ๐Ÿ”ฌ ๐Ÿ’ก

๐Ÿ“Œ WHERE + HAVING Together

๐ŸŒŸ `sql -- Step 1 (WHERE): Sirf 2024-02-01 ke baad ke orders lo -- Step 2 (GROUP BY):โ€ฆ
Topic 8
โœจ

๐Ÿ“Œ WHERE vs HAVING โ€” Detailed Comparison

๐Ÿš€ | Feature | WHERE | HAVING | |---------|-------|--------| | Kab run | GROUP BY se PEHLE |โ€ฆ
Topic 9
๐Ÿ“ฅ ๐Ÿ“ฅ ๐Ÿง  ๐Ÿ”ฌ ๐Ÿ’ก ๐ŸŽฏ

๐Ÿ“Œ HAVING Without GROUP BY

๐Ÿ“š `sql -- Total orders check karo (sab ek group) SELECT COUNT(*) AS TotalOrders FROM Ordersโ€ฆ
Topic 10
๐Ÿ’ก ๐Ÿ“Š ๐Ÿ”ฌ

๐Ÿ“Œ HAVING With JOIN

๐Ÿ’ก `sql -- Customers jinke 2 se zyada orders hain SELECT c.CustomerName, COUNT(o.OrderID) ASโ€ฆ
Topic 11
๐Ÿ”’

๐Ÿ“Œ Multiple HAVING Conditions

๐ŸŽฏ `sql -- Countries jinke 2+ orders hain AUR average order 3000+ hai SELECT Country,โ€ฆ
Topic 12
โญ

๐Ÿ“Œ Complete SQL Clause Order

โญ ` SQL Statement Order (MUST follow): โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ” โ”‚ SELECT โ†โ€ฆ
Topic 13
๐Ÿ“ฅ ๐Ÿ“ฅ ๐Ÿง  ๐Ÿ”ฌ ๐Ÿ’ก ๐ŸŽฏ

โœ… Summary

๐Ÿ”‘ KEY POINTS: - HAVING GROUP BY ke baad groups ko filter karta hai - WHERE rows filterโ€ฆ
Comparison
โœจ

๐Ÿ“Œ WHERE vs HAVING โ€” Detailed Comparison

โš–๏ธ

Kab run: GROUP BY se PEHLE

โš–๏ธ

Kya filter: Individual rows

โš–๏ธ

Aggregate use: โŒ Nahi kar sakta

Quick Quiz
๐Ÿง  QUIZ TIME

Quiz โ€” Question 1

๐Ÿ“˜ SQL HAVING - Groups Ko Filter Karna ka sabse sahi definition kya hai?

Quick Quiz
๐Ÿง  QUIZ TIME

Quiz โ€” Question 2

๐Ÿ“˜ SQL HAVING - Groups Ko Filter Karna ka '101' kya hai?

Complete! ๐ŸŽ‰
COMPLETE

๐Ÿ“˜ SQL HAVING - Groups Ko Filter Karna Complete!

Aliens School ยท HIEN ยท Cinematic Knowledge

โœ…

๐Ÿ“˜ SQL HAVING - Groups Ko Filter Karna Complete

1/19
0:00
REC 00:00ESC=Cancel
Aliens School
3
Recording shuru hone wali hai...
โœ…
Recording Complete
Video process ho rahi hai...
Live Class
Slide 1 / 7
Timer
00:00
๐Ÿ“ Speaker Notes
โ€”
โญ๏ธ Up Next
โ€”
โ€”
๐Ÿ—‚๏ธ All Slides