I've an SQL select statement that I use to display some records within a DataList. Within my database there are duplicate records (not in error, they are supposed to be there), but instead of these duplicates showing in the Datalist for every record; I want just one to be shown.
Records in database:ID Names1 John 182 Sean 183 Michael 194 John 185 William 21
Required selected:John 18Sean 18Michael 19William 21
Does anyone know who to achieve this?
View Complete Post