UnPivot Table In SQL
SQL

In this article, we are going to learn how to use UnPivot Table in SQL. UnPivot is another operation in SQL that perform almost reverse operation of Pivot by transfer data from rows to columns. Let us understand with an example.

Reversing Pivot In SQL
SQL

In this article, we are going to learn how to Reverse and get original table after apply Pivot operation to table in SQL. Reversing Non-aggregate Pivoted Table Reversing a PIVOT operator is only possible if the pivoted table doesn’t contain aggregated data.

Mongo DB Aggregation
SQL

In this Article, we will learn how to get particular document list based on the condition, grouping of data, how to select particular fields from the document as output. All this operation will be preformed by Mongo DB Aggregation.

Merge Query In SQL Server
SQL

We need to perform INSERT, UPDATE, and DELETE operations on a target table by matching with records from the source table. For example, a Stock table has information about the stocks and you need to sync this table with the latest information about the stocks from the source table. We would need to write separate DML commands (INSERT statements, UPDATE statements and DELETE statements) to refresh the target table with an updated stock list in your SQL database. In this tip, we will walk through how to use the MERGE statement.

Convert XML To Table SQL Server
SQL

In this article, we will learn how we can convert XML to a table in SQL Server. XML is one of the most common formats used to share information between different platforms.

Subscribe

Select Categories