add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
(No column name)
Microsoft SQL Server 2019 (RTM-CU16) (KB5011644) - 15.0.4223.1 (X64)
Apr 11 2022 16:24:07
Copyright (C) 2019 Microsoft Corporation
Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)
Id Name Gender Salary Country
1 Mark Male 5000 USA
2 John Male 4500 India
3 Pam Female 5500 USA
4 Sara Female 4000 India
5 Todd Male 3500 India
6 Mary Female 5000 UK
7 Ben Male 6500 UK
8 Elizabeth Female 7000 USA
9 Tom Male 5500 UK
10 Ron Male 5000 USA
Country Gender Total Salary
India Female 4000
India Male 8000
India Total 12000
UK Female 5000
UK Male 12000
UK Total 17000
USA Female 12500
USA Male 10000
USA Total 22500
Total 51500
Country Gender Total Salary (No column name) (No column name)
India Female 4000 0 0
India Male 8000 0 0
India Total 12000 0 1
UK Female 5000 0 0
UK Male 12000 0 0
UK Total 17000 0 1
USA Female 12500 0 0
USA Male 10000 0 0
USA Total 22500 0 1
Grand Total 51500 1 1