DataBeatJourney: Filtering & Sorting (21

Wednesday, May 13, 2026

What does WHERE clause do?
It filters rows based on conditions.
Difference between WHERE and HAVING?
WHERE filters rows before grouping; HAVING filters groups after aggregation.
What is ORDER BY?
It sorts query results in ascending or descending order.
Default sort order in SQL?
Ascending (ASC) by default.
What is DISTINCT?
It removes duplicate values from result.
How do you fetch top 5 records?
SELECT TOP 5 * FROM table; (SQL Server)
How do you fetch first 5 rows in MySQL?
SELECT * FROM table LIMIT 5;
What is BETWEEN?
It filters values within a range.
What is IN operator?
It matches values from a given list.
What is LIKE used for?
It is used for pattern matching.
What does % mean in LIKE?
It matches zero or more characters.
What does _ mean in LIKE?
It matches exactly one character.
How do you handle NULL values?
Use IS NULL or IS NOT NULL.
Can we use = NULL?
No, use IS NULL.
What is alias in SQL?
A temporary name given to a column or table.

DataBeatJourney