Gossamer Forum
Home : General : Databases and SQL :

DISTINCT

Quote Reply
DISTINCT
I can't seem to get a distinct list in MS SQL. I just would like to make the following list have only show the distinct record based on thair emailaddress. (Multiple null's should be allowed.)

1001 ...., ...., .... a@dot.com
1002 ...., ...., .... NULL
1003 ...., ...., .... a@dot.com
1004 ...., ...., .... b@dot.com
1005 ...., ...., .... c@dot.com
1006 ...., ...., .... NULL
1007 ...., ...., .... d@dot.com

So ID 1003 should dissapear... (second time a@dot.com is in the list) Who can assist me in this?

Thanks in advance!
Subject Author Views Date
Post DISTINCT cK 4013 Mar 23, 2004, 3:22 PM