Currently browsing category

Database, Page 6

Introduction to MongoDB

MongoDB is a open-source document-oriented database written in C++ and C and licensed under the GNU Affero General Public License and the …

SQL Pivoting using Case Statement

Using Aggregated CASE Statement I previously illustrated how to using PIVOT table in SQL Server. Today we will cover how to accomplish …

SQL Server Pivot Table Example

What is a Pivot Table? A pivot table can aggregate and rotate data from rows to columns. You can also sort, count …