Distinct Recordz?

Select distinct email,.... from table

Select * from table group by email. 

can you give an example, how you want the records. there are different meaning of your asking.

suppose a table is like this

id fEmail         NAme

1   abcd          tony

 2  efg             raj

 3  abcd         mike

 4 efg             dennis

 what's your output?

if it is,  

abcd

efg

then by the query "select distinct email from tablename" you can get the above result.

if your output is like 1person per 1 mail,

abcd tony

efg    raj

select Email,Name from emails e where Id=(select min(Id) from emails where Email=e.Email) "

SELECT name, tel, email FROM (SELECT name, tel, email,
ROW_NUMBER() OVER(PARTITION BY email ORDER BY name) as rn
FROM  emails) t
WHERE rn=1