more than distinct 1

[MrDontKnowNothing]

hi folks,

when using a distinct on a table, i only get the data one time. that's fine but in the following example it's a little inappropriate...

having a table like this:

id | email
----------------
1 | a@b.com
2 | b@b.com
2 | c@b.com
3 | d@b.com
4 | e@b.com
4 | f@b.com

i want a select stmt wich only returns something like this

id | email
----------------
1 | a@b.com
2 | b@b.com
3 | d@b.com
4 | e@b.com

many thanks in advance!

alex

 

[rgbean]

Try:

SELECT ID, MIN(email) from mytable ;
  GROUP BY ID ;
  ORDER BY ID ;
 INTO CURSOR curRESULT

Rick

 

[craigsboyd]

Star bright Rick!

Slighthaze = NULL
[sub]craig1442@mchsi.com[/sub][sup]

"Whom computers would destroy, they must first drive mad." - Anon​

[/sup]