SQL CASE STATEMENT
The CASE statement has the functionality of an IF-THEN-ELSE . It goes through conditions and returns a value when the first condition is met . So, once a condition is true, it will stop reading and return the result.
Home » SQL Tutorial »
SQL Tutorial
This website provides a SQL Tutorial, SSRS, Power BI, Python, Azure basics and advanced tutorials for beginners and professionals
You will find out a step-by-step walk through of the basics and advanced topics with practical and include numerous hands-on activities.
Schedule a Job in SQL
The SQL Server Agent job is the specified action or series of actions that the SQL Server Agent will execute at any specific date time.
How to display Cumulative total in SQL ?
A Cumulative total or running total refers to the sum of values in all cells of a column that precedes the next cell in that particular column
What is Correlated Subquery in SQL?
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 .
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.
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 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 ORDER BY
SQL ORDER BY keyword is used to sort the result set in ascending or descending order.
SQL Server SUM
SQL Server SUM function is an aggregate that returns the sum of values for any column in a table.
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.
Displaying line numbers in Query Editor Window
we can enable line numbers to be displayed in Sql Server Query Editor Window.
