A correlated subquery is a subquery that uses the values of the outer query and it is evaluated for each row processed by the outer query
A correlated subquery always depends on outer query for its value. Because of this dependency, a correlated subquery cannot be executed independently as a simple subquery .
A Subquery is a query within another query. The outer query is called as main query and inner query is called as sub query.
SQL SERVER ROLLUP clause is used to display subtotals and grand totals in the result set . It is always used with Group By clause.
SQL UNION ALL operator is used to combine the result sets of two or more select statements .
SQL WAITFOR statement is used to blocks the execution of a batch statement, transnational statement or any stored procedure until a specified time or any time interval is reached, or a specified statement modifies or returns at least one row.
The OUTPUT clause returns the values of each row that was affected by an INSERT, UPDATE or DELETE statements.
A stored procedure is a group of SQL statements compiled into one unit for later use and can be used many times.
SQL ORDER BY keyword is used to sort the result set in ascending or descending order.
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 WHERE clause is used to specify a condition while fetching the data from a tables.
SQL Server MAX() function is an aggregate function that is used to find the Maximum or Largest value of a column .
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 TRIM() function is used to remove both Leading and Trailing spaces from any given string It was introduced in SQL Server 2017 version… Read More »SQL TRIM()
