KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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.
Tags (comma-separated)
Save Edits
Cancel