Data Retrieval – Joins, Alias & Filtering

36 makers are attended


Aug 013:00 PM
-
Aug 014:00 PM
Online event
Pre Invite
Campus Exclusive
Study Jams
Learning Program

An event by

Jyothi Engineering College, Cheruthuruthy

Hosts

ANEENA

Harikrishnan

Abhinav

Ann

Nandhana

Nandhana

ANEENA


Topics & themes

Web Development


This section focuses on retrieving data efficiently using joins, aliases, and filtering methods. Aliases (AS): Rename columns or tables for clarity in results. Joins: Combine rows from two or more tables based on related columns. ➤ INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN Filtering & Grouping: Extract specific records and organize them. ➤ WHERE, GROUP BY, HAVING, ORDER BY, LIMIT UNION: Merge results from multiple SELECT queries with same structure