sql statement

SQL GOTO Statement

The SQL GOTO statement is used to alter the flow of execution. When the execution reaches the GOTO statement.

SQL Server CONCAT_WS Function

SQL Server CONCAT_WS() function is a string function that is used concatenates two or more strings together with a separator.

It separates those concatenated string values with the delimiter specified in the first function parameter.

SQL Server Interview Question & Answer Quiz on CREATE statement

SQL SERVER Interview Q & A QUIZ on SUBSTRING()

SQL interview question and answer on Substring function

SQL Server DENSE_RANK()

The DENSE_RANK() is a Ranking function that is used to assign ranks to rows in partitions with no gaps in the ranking values.

SQL RANK()

The RANK() function is a window function that is used to assign a rank to each row in the partition of a result set.

SQL Row_Number() is a ranking function/window function that is used to assign a sequential integer to each row within a partition of a result set. The row number starts with one for the first row in each partition.

SQL SERVER INTERSECT

The SQL INTERSECT clause is used to combine two SELECT statements, but returns rows only from the first SELECT statement that are identical to a row in the second SELECT statement.