Alex Rivera | Logout

How to Select only one unique record from the Table using Distinct

Asked 2010-06-25T09:37:49.207
9

my table have several records which has the same MemberID. i want to result out only one record.

select DISTINCT(MemberID)  from AnnualFees;

then result will come. but i want to show the other column data also but when i do this

select DISTINCT(MemberID),StartingDate,ExpiryDate,Amount  from AnnualFees;

all the details including same MemberID data also displaying.

can someone help me.

Edit
Report

1 Answer

-3

select DISTINCT MemberID,StartingDate,ExpiryDate,Amount from AnnualFees;

remove paranthesis

answered 2010-06-25T09:40:21.910

Your Answer