SQL Window Function | How to write SQL Query using Frame Clause, CUME_DIST | SQL Queries Tutorial

techTFQ November 4, 2021
Video Thumbnail

About

Hi, I am Thoufiq! On this channel, I teach SQL, Python and Database concepts in the field of Data Analytics and Data Science in the most simplest manner possible. If this excites you then do consider subscribing. You will also find videos covering interview questions and also videos where I provide career guidance in the field of Data Analytics and Data Science which should help you find your dream job. I aim to make techTFQ a go to YouTube channel for anyone learning SQL, Python and Databases in the field of Data Analytics and Data Science. Thank you for begin here :)

You May Also Like

Essential Gear for Travel Photogs

AI-recommended products based on this video

Loading...
koolehaoda Professional Gimbal Head Tripod Head Aluminum Alloy Heavy Duty 360° Panoramic with Arca-Swiss Standard 1/4 inch QR Plate for DSLR Cameras up to 55.11lbs/25kg. (GH-3)

koolehaoda Professional Gimbal Head Tripod Head Aluminum Alloy Heavy Duty 360° Panoramic with Arca-Swiss Standard 1/4 inch QR Plate for DSLR Cameras up to 55.11lbs/25kg. (GH-3)

(63)
$168.98
FREE delivery Thu, Jun 19
Loading...
Ball Head Manbily Tripod Head Metal Aluminum Body 360° Panoramic Monopod Head with Extra Arca Swiss Quick Release Plate, Load up to 17.6lbs/8kg,Camera Head for DSLR, Camcorder, Slider (Red)

Ball Head Manbily Tripod Head Metal Aluminum Body 360° Panoramic Monopod Head with Extra Arca Swiss Quick Release Plate, Load up to 17.6lbs/8kg,Camera Head for DSLR, Camcorder, Slider (Red)

(274)
$85.26$77.52
FREE delivery Jun 17 - 19Only 10 left in stock.
Loading...
Heavy Duty Tripod Gimbal Head, Aluminum Alloy 360° Panorama Gimbal with for Arca Swiss Standard Quick Release Plate and Bubble Level, with 1/4 Inch and 3/8 Inch Screws

Heavy Duty Tripod Gimbal Head, Aluminum Alloy 360° Panorama Gimbal with for Arca Swiss Standard Quick Release Plate and Bubble Level, with 1/4 Inch and 3/8 Inch Screws

(0)
$202.00
FREE delivery Jun 27 - Jul 10
Loading...
NEEWER Zf Handgrip L Shape Grip for Nikon Z f, Ultra Thin Retro Formfitting Camera Mounting Baseplate with Handle & Aluminum Shutter Button Cap, Compatible with Arca Swiss Tripod Fluid Head, CA073

NEEWER Zf Handgrip L Shape Grip for Nikon Z f, Ultra Thin Retro Formfitting Camera Mounting Baseplate with Handle & Aluminum Shutter Button Cap, Compatible with Arca Swiss Tripod Fluid Head, CA073

(236)
$33.99
FREE delivery Thu, Jun 19 on your first order
Loading...
Anker USB C Charger Cable (6ft 100W, 2Pack), USB 2.0 Type C Fast Charging Cable for iPhone 15 / 15Pro / 15Plus / 15ProMax MacBook Pro 2020, iPad Pro 2020, iPad Air 4, Samsung Galaxy S23+/S23 Ultra ClimatePartner certified

Anker USB C Charger Cable (6ft 100W, 2Pack), USB 2.0 Type C Fast Charging Cable for iPhone 15 / 15Pro / 15Plus / 15ProMax MacBook Pro 2020, iPad Pro 2020, iPad Air 4, Samsung Galaxy S23+/S23 Ultra ClimatePartner certified

(44,904)
$17.99
FREE delivery Wed, Aug 20 on your first order
6K+ bought in past month
Loading...
Anker USB C Cable, [2-Pack, 6 ft] Type C Charger Premium Nylon USB Cable, USB A to Type C Charging Cable Fast Charge for Samsung Galaxy S10 S10+ / Note 8, LG V20 and Other USB C Charger (Black)

Anker USB C Cable, [2-Pack, 6 ft] Type C Charger Premium Nylon USB Cable, USB A to Type C Charging Cable Fast Charge for Samsung Galaxy S10 S10+ / Note 8, LG V20 and Other USB C Charger (Black)

(103,365)
$13.49
5K+ bought in past month
Loading...
Lexar 128GB Micro SD Card, microSDXC UHS-I Flash Memory Card with Adapter - Up to 100MB/s, A1, U3, Class10, V30, High Speed TF Card

Lexar 128GB Micro SD Card, microSDXC UHS-I Flash Memory Card with Adapter - Up to 100MB/s, A1, U3, Class10, V30, High Speed TF Card

(26,884)
$18.99
FREE delivery Wed, Aug 20 on your first order
5K+ bought in past month
Loading...
Lexar D40E 128GB Dual Drive USB 3.2 Gen 1 Type-C™ Jump Drive, USB-C Flash Drive Metal Housing Swivel Design Thumb Drive

Lexar D40E 128GB Dual Drive USB 3.2 Gen 1 Type-C™ Jump Drive, USB-C Flash Drive Metal Housing Swivel Design Thumb Drive

(2,310)
$22.99
FREE delivery Sun, Aug 10 on your first order
2K+ bought in past month
Loading...
SmallRig Half Cage for Canon R5, R5 C & R6 - Camera Cage with Cable Clamp - 3656

SmallRig Half Cage for Canon R5, R5 C & R6 - Camera Cage with Cable Clamp - 3656

(53)
$87.54
FREE delivery Thu, Jun 19
Loading...
NEEWER a6700 L Plate Compatible with Sony Alpha 6700, Quick Switch Aluminum Extendable Side Plate & Anti Twist Baseplate Compatible with Arca Swiss QR System DJI RS 2 RSC 2 RS 3 Pro Gimbals, CA048

NEEWER a6700 L Plate Compatible with Sony Alpha 6700, Quick Switch Aluminum Extendable Side Plate & Anti Twist Baseplate Compatible with Arca Swiss QR System DJI RS 2 RSC 2 RS 3 Pro Gimbals, CA048

(24)
$25.99
FREE delivery Thu, Jun 19 on your first order
Loading...
SmallRig ZV-E1 Camera Baseplate for Sony ZV-E1, Built-in Cold Shoe Mount and QR Plate (for Arca) Quick Switch Between Tripod and Stabilizer for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro - 4314

SmallRig ZV-E1 Camera Baseplate for Sony ZV-E1, Built-in Cold Shoe Mount and QR Plate (for Arca) Quick Switch Between Tripod and Stabilizer for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro - 4314

(3)
$44.99
FREE delivery Thu, Jun 19
Loading...
NEEWER a6700 L Plate Compatible with Sony Alpha 6700, Quick Switch Aluminum Extendable Side Plate & Anti Twist Baseplate Compatible with Arca Swiss QR System DJI RS 2 RSC 2 RS 3 Pro Gimbals, CA048

NEEWER a6700 L Plate Compatible with Sony Alpha 6700, Quick Switch Aluminum Extendable Side Plate & Anti Twist Baseplate Compatible with Arca Swiss QR System DJI RS 2 RSC 2 RS 3 Pro Gimbals, CA048

(24)
$25.99
FREE delivery Thu, Jun 19 on your first order
Loading...
SmallRig Baseplate for Sony Alpha 6700, Bottom Mount Plate Built-in Quick Release Plate for Arca, Supporting Quick Switch Between Tripod and Stabilizer (for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro) - 4338

SmallRig Baseplate for Sony Alpha 6700, Bottom Mount Plate Built-in Quick Release Plate for Arca, Supporting Quick Switch Between Tripod and Stabilizer (for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro) - 4338

(85)
$38.24
FREE delivery Thu, Jun 19
Loading...
DJI Mic Mini (2 TX + 1 RX), Detail-Rich Audio, Wireless Lavalier Microphone for Camera/Android, 2-Person Vlog, Team Production
Best Seller

DJI Mic Mini (2 TX + 1 RX), Detail-Rich Audio, Wireless Lavalier Microphone for Camera/Android, 2-Person Vlog, Team Production

(59)
$99.00
FREE delivery Tue, Oct 7
500+ bought in past month
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...
D-Link AC1300 USB WiFi Adapter | 2.4/5GHz Dual Band Wireless Internet Travel Size for Desktop PC Laptop | MU-MIMO Plug & Play | Supports Windows 10/11 Drivers | WPA3 Enhanced Security (AC13U-CA)

D-Link AC1300 USB WiFi Adapter | 2.4/5GHz Dual Band Wireless Internet Travel Size for Desktop PC Laptop | MU-MIMO Plug & Play | Supports Windows 10/11 Drivers | WPA3 Enhanced Security (AC13U-CA)

(1,357)
$22.49
FREE delivery Sun, Jun 22 on your first order