9 docs tagged with "clauses"

SQL Aliases (AS) | Renaming Columns & Tables

Learn how to use SQL aliases to give temporary, readable names to your columns and tables. Perfect for complex joins and math operations. Complete.

SQL DISTINCT Clause | Removing Duplicate Results

Learn how to use the SELECT DISTINCT statement to retrieve unique values from a table. Understand how it works with multiple columns. Complete.

SQL GROUP BY Clause | Categorizing Results

Learn how to use the SQL GROUP BY clause to arrange identical data into groups. Often used with aggregate functions for reporting. Complete practical.

SQL HAVING Clause | Filtering Grouped Data

Master the SQL HAVING clause. Learn why WHERE cannot be used with aggregates and how to filter your GROUP BY results effectively. Free student exam study guide.

SQL LIMIT, FETCH, & TOP | Pagination in SQL

Learn how to limit the number of rows returned by a query. Syntax for MySQL LIMIT, SQL Server TOP, and Oracle FETCH FIRST. Free practical study guide for exams.

SQL ORDER BY Clause | Sorting Query Results

Learn how to sort your SQL results alphabetically, numerically, and by date using the ORDER BY clause. Covers ASC and DESC keywords. Complete.

SQL Query Clauses | Refine, Sort, & Paginate

Learn how to use SQL clauses like WHERE, ORDER BY, and LIMIT to refine your search results and improve application performance. Free student exam study guide.

SQL WHERE Clause | Filtering Data Precisely

Master the SQL WHERE clause. Learn how to filter rows based on specific conditions using comparison and logical operators. Free practical study guide for exams.

SQL WITH Clause (CTE) | Common Table Expressions

Master the SQL WITH clause. Learn how to create Common Table Expressions (CTEs) to make complex queries readable and modular. Complete student exam study guide.