I am a computer science engineering student with an informatics practices background.
I am a good orator and a creative writer.

Divya Lakhotia

Grouping records in a table,  using group by clause and joining multiple tables.

GATE (Graduate Aptitude Test in Engineering) 2020 & 2021 complete preparation with best educators. Know about the detailed syllabus, best books, exam pattern and dates, previous year question papers a

GATE - Iconic Pro

English

GATE: SQL - Grouping Records and Table Joins

Database Management System

CS & IT

GATE - CSIT, DSAI & Interview Preparation

GATE, ESE and IIT-JAM

Ace the toughest competitive and government exams in India 

Test Preparation

Introduction to grouping and joining tables and types of SQL statements

Overview

Aggregate ( group) functions
Sum(),min(),max(),count(),avg()

Aggregate(Group) Functions

Group by clause,  having clause and how to apply these clauses and their Significance.

Grouping Results - Group by Clause.

Table Joins

Joins Examples And Exercise, Key Points

Code HELLOSONU01 | 8+ Years Teaching Exp. in GATE CS IT & GATE DS AI on Unacademy | Mentored 2 Lakh+ Students | Produced Rankers Under 500

Sweta Kumari

In this course , I will cover The concepts of Relational model with all topics covered in GATE Syllabus.

(Hindi) Relational Model GATE Syllabus with PYQs

In this Course, Sweta Kumari will Cover Previous Year Questions on SQL & Relational Model.

(Hindi) SQL and Relational Model Previous Year Questions - GATE(CS and IT)

This course will cover Joins topic in SQL. I will describe type of joins in this course with important examples.

(Hindi) SQL Joins With Tabular Examples - GATE (CS/IT)

Hi, I'm Jigyasa Agrawal,
 Currently pursuing B.Tech in computer engineering at GBPUAT pantnagar.

Jigyasa Agrawal

This is the fourth course in SQL. Here you will learn the sub queries in SQL.

(Hindi) Basics of SQL - Part 4

B.Tech(IT) undergrad from IIIT Allahabad || Android developer and passionate programmer || loves to code and teaching 

Suraj Singh

This course is consist of queries in sql which is a major part in sql. with the help of queries, we have all the functionality, whether it be searching, inserting something in table and much more.

(Hindi) Queries in SQL - Simple to Complex

This Course will cover Normalization in Databases with 25 Previous Year Questions plus some practice questions from beginning level to expert. This Course is beneficial for 
GATE (CS and IT)
 aspirants.

Lessons

5 lessons • 43m

Invalid Date

NaN

Overview

Invalid Date

NaN

Aggregate(Group) Functions

Invalid Date

NaN

Grouping Results - Group by Clause.

Invalid Date

NaN

Table Joins

Invalid Date

NaN

Joins Examples And Exercise, Key Points