By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
(No column name) |
---|
Microsoft SQL Server 2012 (SP4) (KB4018073) - 11.0.7001.0 (X64) Aug 15 2017 10:23:29 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor) |
name | surname |
---|---|
John | John |
John | John |
Jessica | Madson |
Jessica | Madson |
Suraj | Kumar |
Peter | Smith |
name | surname | RN |
---|---|---|
Jessica | Madson | 1 |
John | John | 1 |
Suraj | Kumar | 1 |