SQL SERVER

SQL Server Tutorials| Basics & Advance Concepts | Interview Question & Answer Series | SQL Server Tricks & Tips

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 VIEW

A view is a virtual table based on the result set of an SQL statement.

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 Server SUM

SQL Server SUM function is an aggregate that returns the sum of values for any column in a table.

SQL Server AVG

SQL AVG function is an aggregate function that returns the average of the values.

SQL REPLICATE()

SQL REPLICATE() Repeats a string value a specified number of times.

SQL FULL OUTER JOIN

SQL FULL JOIN or FULL OUTER JOIN returns rows from both left and right tables, with the matching rows from both tables where available. If there is no match, the missing side will have null values.