Running Total In SQL Server

By
Running total refers to the sum of values in all cells of a column that precedes the next cell in that particular column.

Using Window Function

Assuming, the table has 2 columns, col1 is primary key with data type integer and col2 is integer data type values. To calculate running total on col2 write a query as

select col1, col2,sum(col2) over(order by col1) as runnintotal from tablename

using window function is more performance efficient.

Comments

Post a Comment

Popular posts from this blog

How to retrieve texts from Html SharePoint List source in Power BI

By
Image
Recently I have been put in to a scenario where I need data from SharePoint list to be published into Power BI Report. The columns used in SharePoint list where of type Multi Line Text and contained HTML tags. Up here I am going to show how to consume HTML in Power BI reports, Power BI itself offers way to clean your HTML text allowing you to use only text from it. Step 1: Connect to SharePoint List  using PowerBI Step 2: Select Transform Data Step 3: Find column FieldValueAsHtml, click to expand and select the column with Html data and click ok. This will extract the column data and create a new column with only texts extracted from Html. This new column will be called FieldValueAsHtml.YourColName. Enjoy.
Read more

Simplifying Data Migration: Debezium for Moving Data from Oracle to SQL Server

By
 Introduction In today's data-driven world, organizations rely on databases to store, manage, and analyze vast amounts of information. Over time, businesses may need to change database systems for various reasons, such as cost-efficiency, performance improvements, or compatibility with new applications. One common migration scenario is moving data from Oracle, a popular relational database, to SQL Server, another widely used database system. While data migration can be a complex task, tools like Debezium have emerged to simplify and streamline the process. What is Debezium? Debezium is an open-source, distributed platform for change data capture (CDC). It captures changes to database data in real-time, making it an excellent choice for scenarios like Oracle to SQL Server data migration. Debezium works by monitoring the database's transaction log and recording any changes made to the data, such as inserts, updates, and deletes. This captured data is then made available in a form...
Read more

Installing MariaDB on Ubuntu using SUDO

By
This article demonstrate steps to install MariaDB/MySQL on Ubuntu using sudo. This is part of our getting started journey to learn MariaDB/MySQL. I will be covering PostgreSQL in another article. Before we get started, very first step would be to install MariaDB/MySQL Server and client. You can install any of these RDBMS on Windows but this blog will mostly be following Ubuntu OS. There are various tools to access MariaDB/MySQL Server, we are going to use mysqlclient and Heidisql. Lets get started with installation of MariaDB. Step 1: Open your Ubuntu terminal window or bash and run following cmd. This step is going to check if mariadb-server is already installed and is going to remove it. You can either continue using the current setup or go to next step to do a fresh installation sudo apt-get remove mariadb-server Step 2: run sudo apt-get install software-properties-common Step 3: Check for Ubuntu updates sudo apt-get updates Step 4: Install Ubuntu updates sudo ...
Read more