Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Name BillingContactEmail
- Peter a@a.com
- Andy a@a.com
- Halla b@b.com
- Name BillingContactEmail
- Peter a@a.com
- Halla b@b.com
- select max(Name) as Name, BillingContactEmail
- from t
- group by BillingContactEmail;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement