sql - Where Statement w/ Distinct -

sql - Where Statement w/ Distinct -

i have big table purposes of question, let's assume have follwoing column strucure:

i'd have statement returns rows e-mail address distinct in particular column.

thoughts?

in databases, can this

select t.accountid, t.billingemail (select t.*, count(*) on (partition billingemail) cnt t ) t cnt = 1

the advantage of approach can many columns table.

sql where