How to get distinct values values in two columns: 'borrower' and 'owner' using only "OR" keyword

Loopedfrog4 0
Viewed 29

How do to get all distinct email value that exists in either columns or both using "OR" operator

enter image description here

distinct keyword sql
1 Answers

You can try it:

select distinct  Result from
(select browser ,owner  from emp
) s
unpivot (Result for col in (browser,owner)) as t2

https://dbfiddle.uk/1zR-iPHQ

Prabhakar Anand0
Related