|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
displaying duplicates only once
Hi,
I have a database which contrains some duplicate data. on my asp page i need to display this data in a selection list, the problem is the selection list displays all the same data quite a number of times which i dont want it to do, i just want 2 display each data only once? does anyone have any idea as to how i can go about this? Cheers |
|
#2
|
|||
|
|||
|
Try a DISTINCT Select Statement
It should remove duplicate data from the recordset S- |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > displaying duplicates only once |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|