What is SubQuery in SQL ?
A Subquery is a query within another query. The outer query is called as main query and inner query is called as sub query.
Home » Archives for Pradeep Raturi »
Pradeep Raturi
I have 11+ years of working experience in Business Intelligence Data Modelling, Power BI, SQL Server, SSRS, SSIS, Azure Data Factory, Power Apps.
SQL SERVER ROLLUP
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
SQL UNION ALL operator is used to combine the result sets of two or more select statements .
SQL WAITFOR
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.
SQL ERROR HANDLING WITH TRY..CATCH
The TRY CATCH block is used to handle exceptions in Transact-SQL code .
SQL Server PIVOT
SQL PIVOT allow us to aggregate the results and rotate rows into columns so in sort, we can say using PIVOT
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.