Lec-40: Self Join operation with Example | Database Management System

Gate Smashers • August 25, 2018
Video Thumbnail
Gate Smashers Logo

Gate Smashers

View Channel

About

Welcome to Gate Smashers, one of the fastest-growing EdTech communities with 2.45M+ learners. 🎓 We provide complete lectures for B.Tech CSE, GATE CSE, UGC NET CS, IT Officer, and PGT/TGT CS exams. On this channel, you will learn step-by-step with real life examples related to DSA, OS, DBMS, CN, TOC, Compiler, Software Engineering, Programming, Placement Prep, AI, ML, Cybersecurity, Cloud, Big Data & Emerging Tech. Why Gate Smashers? 1. Complete syllabus (B.Tech, GATE, NET, IT Officer, PGT/TGT) 2. Core + Advanced (AI, ML, Cloud, Cybersecurity) 3. Simplified explanations to save time 4. Placement & Govt. exam guidance 5. Trusted by millions of learners Our Mission is to empower learners to master Computer Science & succeed in: 1. GATE CSE & NET CS 2. Govt. & IT Officer Exams 3. Teaching (PGT/TGT CS) 4. Careers in AI, ML, Cloud & Cybersecurity 5. Strong CS fundamentals for placements 📌 Gate Smashers – Learn. Practice. Smash Your Goals.

You May Also Like

Upgrade Your Gear

AI-recommended products based on this video

Loading...
SmallRig NATO Clamp to Quick Release Plate for Arca-Swiss, Built-in NATO Clamp, Lightweight and Easy to Carry, Compatible with Tripods for Arca-Type - MD4857

SmallRig NATO Clamp to Quick Release Plate for Arca-Swiss, Built-in NATO Clamp, Lightweight and Easy to Carry, Compatible with Tripods for Arca-Type - MD4857

(32)
$23.79
FREE delivery Thu, Jun 19 on your first order
Loading...
TERRAMASTER F8 SSD Plus NAS - 8Bay All SSD NAS Storage Core i3 8-Core 8-Thread CPU, 16GB DDR5 RAM, 10GbE Port, 8 Heat Sinks Included, Palm-Sized Network Attached Storage Peak Performance (Diskless)

TERRAMASTER F8 SSD Plus NAS - 8Bay All SSD NAS Storage Core i3 8-Core 8-Thread CPU, 16GB DDR5 RAM, 10GbE Port, 8 Heat Sinks Included, Palm-Sized Network Attached Storage Peak Performance (Diskless)

(35)
$1,099.99
FREE delivery Mon, Aug 11
Loading...
ZDZA Electric Bike, 1000W Peak Motor, 26” Electric Mountain Bike, 35km/h &65 km Max Range Ebike for Adults, Electric Bicycle for Commute, Colorful LCD Display & 7 Speed
Best Seller

ZDZA Electric Bike, 1000W Peak Motor, 26” Electric Mountain Bike, 35km/h &65 km Max Range Ebike for Adults, Electric Bicycle for Commute, Colorful LCD Display & 7 Speed

(72)
$799.99
FREE delivery Jul 8 - 10
200+ bought in past month
Loading...
CIYOYO Head Strap for Meta Quest 3/3S, 10000mAh Battery Pack for Oculus Quest 3S/3 Accessories, Extended 6H Playtime with Enhanced Comfort and Balance, Adjustable Elite Strap, Free Lens & Case Cover

CIYOYO Head Strap for Meta Quest 3/3S, 10000mAh Battery Pack for Oculus Quest 3S/3 Accessories, Extended 6H Playtime with Enhanced Comfort and Balance, Adjustable Elite Strap, Free Lens & Case Cover

(181)
$62.99
Loading...
AKASO V50 Elite 4K60fps Touch Screen WiFi Action Camera Voice Control EIS 131 feet Waterproof Camera 8X Zoom Remote Control with with 64GB U3 MicroSDXC Memory Card Global Recycled Standard

AKASO V50 Elite 4K60fps Touch Screen WiFi Action Camera Voice Control EIS 131 feet Waterproof Camera 8X Zoom Remote Control with with 64GB U3 MicroSDXC Memory Card Global Recycled Standard

(848)
$219.99
FREE delivery Sun, Aug 24
Loading...
SanDisk 256GB Ultra microSDXC UHS-I Memory Card with Adapter - Up to 150MB/s, C10, U1, Full HD, A1, MicroSD Card - SDSQUAC-256G-GN6MA

SanDisk 256GB Ultra microSDXC UHS-I Memory Card with Adapter - Up to 150MB/s, C10, U1, Full HD, A1, MicroSD Card - SDSQUAC-256G-GN6MA

(217,850)
$24.63$19.70
FREE delivery Wed, Aug 20 on your first order
5K+ bought in past month
Loading...
Amazon Basics 64GB microSDXC Memory Card with Full Size Adapter, 100MB/s, U3, 2-Pack

Amazon Basics 64GB microSDXC Memory Card with Full Size Adapter, 100MB/s, U3, 2-Pack

(18,727)
$21.99$20.39
FREE delivery Sun, Aug 10 on your first order
500+ bought in past month
Loading...
SanDisk 64GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXU-064G-GN4IN

SanDisk 64GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXU-064G-GN4IN

(71,074)
$21.99$16.59
FREE delivery Sun, Aug 10 on your first order
500+ bought in past month
Loading...
TAURI for iPhone 17 Pro Max Case 6.9" with 1-Pack Screen Protector, Camera Lens Full Protection, Military-Grade Protection, Shockproof Transparent Back Bumper Phone Cover - Clear Global Recycled Standard

TAURI for iPhone 17 Pro Max Case 6.9" with 1-Pack Screen Protector, Camera Lens Full Protection, Military-Grade Protection, Shockproof Transparent Back Bumper Phone Cover - Clear Global Recycled Standard

(0)
$10.76
FREE delivery Thu, Oct 16 on your first order
2K+ bought in past month
Loading...
Ailun 3 Pack Screen Protector for iPhone 17 [6.3 inch] + 3 Pack Camera Lens Protector with Installation Frame,Sensor Protection,Dynamic Island Compatible,Case Friendly Tempered Glass Film

Ailun 3 Pack Screen Protector for iPhone 17 [6.3 inch] + 3 Pack Camera Lens Protector with Installation Frame,Sensor Protection,Dynamic Island Compatible,Case Friendly Tempered Glass Film

(216,515)
$9.67
Prime
2K+ bought in past month
Loading...
TAURI for iPhone 17 Pro Case 6.3" with 1-Pack Screen Protector, Camera Lens Full Protection, Military-Grade Protection, Shockproof Transparent Back Bumper Phone Cover - Clear Global Recycled Standard
Best Seller

TAURI for iPhone 17 Pro Case 6.3" with 1-Pack Screen Protector, Camera Lens Full Protection, Military-Grade Protection, Shockproof Transparent Back Bumper Phone Cover - Clear Global Recycled Standard

(61,696)
$10.76
Prime
2K+ bought in past month
Loading...
Ailun 3 Pack Screen Protector for iPhone 17 Pro [6.3 inch] + 3 Pack Camera Lens Protector with Installation Frame,Sensor Protection,Dynamic Island Compatible,Case Friendly Tempered Glass Film

Ailun 3 Pack Screen Protector for iPhone 17 Pro [6.3 inch] + 3 Pack Camera Lens Protector with Installation Frame,Sensor Protection,Dynamic Island Compatible,Case Friendly Tempered Glass Film

(216,323)
$9.67
Prime
Loading...
tomtoc 360° Protective Laptop Sleeve for 15-inch MacBook Air M4/A3241 2025, M3/A3114 2024, M2/A2941 2023, 15-inch MacBook Pro A1990 A1707, Dell XPS 15 Plus Laptop, Water-Resistant Computer Case Bag Global Recycled Standard

tomtoc 360° Protective Laptop Sleeve for 15-inch MacBook Air M4/A3241 2025, M3/A3114 2024, M2/A2941 2023, 15-inch MacBook Pro A1990 A1707, Dell XPS 15 Plus Laptop, Water-Resistant Computer Case Bag Global Recycled Standard

(12,968)
$39.55
FREE delivery Tue, Jun 17
Loading...
SINRAOEE 24 MP 18X High-Definition Digital 1080 FHD 3 Inch TFT LCD Screen Anti-Shake Digital Video Camera for Travel

SINRAOEE 24 MP 18X High-Definition Digital 1080 FHD 3 Inch TFT LCD Screen Anti-Shake Digital Video Camera for Travel

(0)
$58.79
FREE delivery Aug 18 - 27
Loading...
LICAEVEY 84MP Digital Camera, 6K 18X Optical Zoom Wide Angle DSLR Camera, 1500mAh Li Battery 3 Inch LCD Vlogging Camera for Travel Recording Video (Black)

LICAEVEY 84MP Digital Camera, 6K 18X Optical Zoom Wide Angle DSLR Camera, 1500mAh Li Battery 3 Inch LCD Vlogging Camera for Travel Recording Video (Black)

(0)
$124.30
FREE delivery Aug 19 - 29
Loading...
LICAEVEY 4K Digital Camera, 75MP UHD 3 Inch LCD Screen Point and Shoot Camara with Flash, 18X Digital Zoom Compact Vlog Travel Camara for Photography (Black)

LICAEVEY 4K Digital Camera, 75MP UHD 3 Inch LCD Screen Point and Shoot Camara with Flash, 18X Digital Zoom Compact Vlog Travel Camara for Photography (Black)

(0)
$70.45
FREE delivery Aug 19 - 29
Loading...
4K HD Digital Camera, 18X Zoom Selfie Vlogging Camera Autofocus with 2.8 Inch LCD Display, Portable 64MP Compact Video Camcorder Anti Shake for Travel (Black)

4K HD Digital Camera, 18X Zoom Selfie Vlogging Camera Autofocus with 2.8 Inch LCD Display, Portable 64MP Compact Video Camcorder Anti Shake for Travel (Black)

(0)
$49.26
FREE delivery Aug 19 - 29
Loading...
AKASO V50 Elite 4K60fps Touch Screen WiFi Action Camera Voice Control EIS 131 feet Waterproof Camera 8X Zoom Remote Control with with 64GB U3 MicroSDXC Memory Card Global Recycled Standard

AKASO V50 Elite 4K60fps Touch Screen WiFi Action Camera Voice Control EIS 131 feet Waterproof Camera 8X Zoom Remote Control with with 64GB U3 MicroSDXC Memory Card Global Recycled Standard

(848)
$219.99
FREE delivery Sun, Aug 24
Loading...
Selfie Stick, 7 Section Adjustable Action Camera Extension Pole with 1/4in Thread and Screw Hole, 23.5 to 120cm Portable Extension Rod for Panoramic Camera

Selfie Stick, 7 Section Adjustable Action Camera Extension Pole with 1/4in Thread and Screw Hole, 23.5 to 120cm Portable Extension Rod for Panoramic Camera

(0)
$14.49
FREE delivery Aug 27 - Sep 17
Loading...
NEEWER Advanced 18 inch LED Ring Light for Phone, LCD Touch Screen, 2.4G Remote Lights Control, 3200-5600K, Tripod Light for iPhone Action Camera, for Studio Makeup TikTok YouTube Video Salon (Black)

NEEWER Advanced 18 inch LED Ring Light for Phone, LCD Touch Screen, 2.4G Remote Lights Control, 3200-5600K, Tripod Light for iPhone Action Camera, for Studio Makeup TikTok YouTube Video Salon (Black)

(2,807)
$181.49
FREE delivery Sun, Aug 10
Loading...
DJI Osmo Action 4 Standard Combo, 4K/120fps Waterproof Action Camera with a 1/1.3-Inch Sensor, Stunning Low-Light Imaging,10-bit & D-Log M Color Performance, Long-Lasting 160 Mins, Outdoor Camera

DJI Osmo Action 4 Standard Combo, 4K/120fps Waterproof Action Camera with a 1/1.3-Inch Sensor, Stunning Low-Light Imaging,10-bit & D-Log M Color Performance, Long-Lasting 160 Mins, Outdoor Camera

(3,962)
299.00
PrimeFREE delivery Saturday, June 14
500+ bought in past month