Unlock the Power of Open Source! The " Linux New " SWAYAM Plus Course is live now and about 2,500 learners have already registered for it.

If you are a registered learner, the forum page is now active. Visit the page and get all your questions answered.

Select with Aggregate functions - English

This is a sample video. To access the full content,
please Login

No questions yet

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

Assignment

Script

Timed Script

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.