Select with Aggregate functions - English

Play

Current Time 0:00

Duration Time 0:00

Remaining Time -0:00

Loaded: 0%

Progress: 0%

0:00

Fullscreen

00:00

Mute

No questions yet

6/9

Outline:
DISTINCT clause in SELECT statement
How to use BETWEEN operator in SELECT statement
How to use LIKE operator in SELECT statement
Usage of percent and underscore wildcards with examples
IN operator in SELECT statement
Aggregate functions
List of aggregate functions
How to use count, sum ,max functions with examples
Count function with Null
WHERE condition in aggregate functions

Width:	992	Height:	640
Duration:	00:11:17	Size:	3.4 MB

Show video info

Pre-requisite

Select statement

Slides

Slide-SelectAggregate/
Slide-SelectAggregate/select-aggregate.pdf
Slide-SelectAggregate/st-logo.png
Slide-SelectAggregate/select-aggregate.tex

Spoken Tutorial, created on or before 31 Jan. 2025, by IIT Bombay is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License, except where stated otherwise
Based on a work at https://spoken-tutorial.org. Permissions beyond the scope of this license may be available at https://spoken-tutorial.org.

Spoken Tutorial, developed at IIT Bombay, is brought to you by EduPyramids Educational Services Private Limited (DBA: EduPyramids Educational Services Pvt Ltd.). EduPyramids Educational Services Private Limited is currently incubated at SINE IIT Bombay. All transactions will be processed under the name EduPyramids Educational Services Private Limited.

Select with Aggregate functions - English

Outline:

Assignment

Script

Timed Script

Slides

Software Training

Procedures

Training

Online Test

Select with Aggregate functions - English

Outline:

Assignment

Script

Timed Script

Slides