Posts in: Oracle SQL Bootcamp
GROUP BY and HAVING
Learn to group rows and apply aggregate functions using GROUP BY. Use HAVING to filter grouped results.
Read More →Aggregate Functions
Explore built-in SQL aggregate functions like COUNT, SUM, AVG, MIN, and MAX for summarizing data.
Read More →ROLLUP and CUBE
Use ROLLUP and CUBE to generate subtotals and grand totals automatically while grouping data.
Read More →GROUPING Functions
Learn how to use GROUPING and GROUPING_ID to distinguish between NULLs in GROUP BY and ROLLUP/CUBE results.
Read More →SQL Functions
Explore the different categories of SQL functions available in Oracle for string manipulation, numbers, dates, and type conversions.
Read More →