i have table with multiple records in a field name Comments... with my aspx code the data in comments column gets inserted in three rows with different requirementcommentid but the field comment will remain same to retrieve distinct i used this queryi have table with multiple records in a field n