|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
November 8th, 2003, 09:32 AM
|
|||
|
|||
selecting duplicate records
I'm using Access as my database, i'm trying to select duplicate records from the database. I've thought of using the 'Distinct' keyword, but i want to select or view the records which are not filtered by the distinct keyword. Let say I have 10 records in my database and 4 of them are identical, if i used the distinct keyword it'll show me a total of 7 records, correct? But i want to view the other 3 records which has not been included, how am going to that? Please help
|
|
#2
November 8th, 2003, 10:05 AM
|
|||
|
|||
|
My suggestion:If u have some recordset are indentical,u can get the record which count is the max in the records:use select count statement to get each record count,And if a record's count is the max,U will get the record which u wanna!...
|
|
#3
November 9th, 2003, 01:57 AM
|
|||
|
|||
|
thanks cleverpig for the idea!
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > selecting duplicate records |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
