Author Archives: user

SQL – Having Clause Table of content The SQL HAVING Clause The SQL HAVING clause is similar to the WHERE clause; both are used to filter rows in a table based on specified criteria. However, the HAVING clause is used to filter grouped rows instead of single rows. These rows are grouped together by the […]

SQL – DISTINCT Keyword Table of content The SQL DISTINCT Keyword The SQL DISTINCT keyword is used in conjunction with the SELECT statement to fetch unique records from a table. We use DISTINCT keyword with the SELECT statetment when there is a need to avoid duplicate values present in any specific columns/tables. When we use […]

SQL – Group By Clause Table of content The SQL GROUP BY Clause The SQL GROUP BY clause is used in conjunction with the SELECT statement to arrange identical data into groups. This clause follows the WHERE clause in a SELECT statement and precedes the ORDER BY and HAVING clauses (if they exist). The main […]