-
HOW TO USE TUPLE IN PYTHON?
TUPLE A Tuple is an ordered and unchangeable collection of python objects, each object is separated by a comma and the whole set is enclosed by parenthesis. Tuples allow duplicate values. Properties of TUPLE Tuple items or objects are ordered, unchangeable, and allow duplicate values. Tuple items are indexed, the first item has an index…
-
WHAT IS PIVOT AND UNPIVOT IN SQL SERVER
PIVOT and UNPIVOT are relational operators. PIVOT rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output. And PIVOT runs aggregations where they’re required on any remaining column values that are wanted in the final output. UNPIVOT carries out the opposite operation to PIVOT…
-
WHAT IS CTE OR COMMON TABLE EXPRESSION IN SQL SERVER
WHAT IS CTE OR COMMON TABLE EXPRESSION IN SQL SERVER?
-
WHAT IS WINDOW FUNCTION IN SQL SERVER
WHAT IS WINDOW FUNCTION IN SQL SERVER?