SQL Server PIVOT
SQL PIVOT allow us to aggregate the results and rotate rows into columns so in sort, we can say using PIVOT
Home » SQL basics to Advance Tutorial »
SQL basics to Advance Tutorial
SQL MERGE
SQL MERGE statement is used to modify data in a target table based on data in a source table.
SQL HAVING CLAUSE
SQL HAVING clause specifies that a SQL select statement should only return rows where aggregate values meet the specified conditions.
SQL GROUP BY
SQL GROUP BY Statement is used to arrange identical data into groups with the help of Aggregate functions.
SQL Server OUTPUT CLAUSE
The OUTPUT clause returns the values of each row that was affected by an INSERT, UPDATE or DELETE statements.
SQL Server Stored Procedure
A stored procedure is a group of SQL statements compiled into one unit for later use and can be used many times.
SQL Server ORDER BY
SQL ORDER BY keyword is used to sort the result set in ascending or descending order.
SQL CROSS JOIN
SQL CROSS JOIN returns a result set which is the number of rows in the first table multiplied by the number of rows in the second table if no WHERE clause is used along with CROSS JOIN
SQL SERVER WHERE
SQL WHERE clause is used to specify a condition while fetching the data from a tables.
SQL Server MAX
SQL Server MAX() function is an aggregate function that is used to find the Maximum or Largest value of a column .
SQL Server MIN
SQL Server MIN() function is an aggregate function that is used to find the smallest or minimum value of a column
SQL COUNT
SQL Server COUNT() function is an aggreagate function that returns the number of rows in a table . It sets the number of rows or non NULL column values.
SQL CHARINDEX()
SQL CHARINDEX() function searches for a substring inside a string starting from a specified location.
SQL SUBSTRING()
SQL SUBSTRING()functions extracts a substring with a specified length starting from a location in an input string.
SQL Server DELETE
SQL delete statement is used to delete records from table based on specific conditions which are passed in where clause.
SQL TRUNCATE TABLE
SQL TRUNCATE TABLE statement is used to delete complete data from an existing table. It is similar to a delete statement without a WHERE clause.
Primary Key VS Composite Key?
A PRIMARY KEY constraint uniquely identifies each record in a table .
A COMPOSITE KEY is a combination of two or more columns in a table that can be used to uniquely identify each row in the table when the columns are combined uniqueness is guaranteed, but when it taken individually it does not guarantee uniqueness.
SQL SERVER DISTINCT
SQL SERVER DISTINCT keyword is used to remove all the duplicate records and fetching only unique records from any table.
- « Previous
- 1
- …
- 4
- 5
- 6