Compute and Compute By in Sql Server

Written By:- Isha Malhotra
Our Website:-Tech Altum

Compute and Compute By

Sometimes in your records you need to show all data of table with some aggregate.

For example:-

See the data of following table:-

Figure 1

Suppose I want to show the data of all columns and after that I want to show the count of gender.

In this situation we will use the compute in following way:-