DISTINCT statement

[aw23]

I have the following query:

select distinct name, datetime,email,amount from table where datetime >= '1/1/2003'
and description in ('Membership')
order by datetime


My problem is the following, there are many duplicate names in the database, however the subsequent information is different. So distinct is doing nothing. I want it to only select all the data for the distinct names.

 

[jshanoo]

hi,
distinct will reteive distinct fields u have specified.

u have to do grouping

thread183-848497

try this post.
some one help me in this regard. If ur problem is solved post a star mark for him.


Regards
John philip


*** Even the Best, did the Bad and Made the Best ***

John Philip