SQLServerLog.com

Category: SQL Commands

0

SQL Commands / SQL Server

SQL GROUP BY Clause

490viewsThe 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...

0

SQL Commands / SQL Server

SQL CREATE TABLE Statement

380viewsA table is primarily a list of useful items or a group of lists and to manage such list it should be organised. To organise this information it is divided into rows and columns....

0

SQL Commands / SQL Server

SQL ORDER BY Clause

535viewsORDER 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:...

0

SQL Commands / SQL Server

SELECT DISTINCT Statement

490views 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,...

0

SQL Commands / SQL Server

SQL WHERE Clause

384viewsThe 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:...