SQL HAVING Clause
322views The HAVING clause allows us to specify conditions on the rows for each group in combination with the GROUP BY clause (see the GROUP BY clause), the HAVING clause is evaluated after rows...
Author: Taiba Hamid
SQL GROUP BY Clause
533viewsThe GROUP BY clause is used to summarize data based on grouping criteria. For each group one column is returned in result set. Syntax SELECT expression1, expression2, … expressionN, aggregate_function (aggregate_expression) FROM TableName WHERE conditions GROUP...
SQL ORDER BY Clause
545viewsORDER BY clause is used to sort the data in ascending or descending order, in SQL Server by default data will not be inserted in any order even if you have an index. Syntax:...
SELECT DISTINCT Statement
522views DISTINCT clause is used to remove the duplicate records from result set, The DISTINCT clause is used only with SELECT statement. Syntax SELECT DISTINCT [ColumnNames] FROM TableName We will start with an example,...
SQL WHERE Clause
406viewsThe WHERE clause is used to restrict the number of rows returned by SELECT statement, in this case SELECT statement return the rows only if the condition specified in the WHERE clause is satisfied. Syntax:...
SQL Aliases
345viewsSometimes you want to change the column names to make them more readable, SQL aliases are used to change the names of tables or columns headings, it is used as follows: Syntax SELECT column_name AS...
