N
Nick Charles
Apologies in advance, im sure this is straight forward.
1 table: tbl_tmp
consists of records (trades)
i want to select all rows where data in certain fields are duplicated.
ie.
id. trnNum fund amt type
1. 123 ABC 123 P
2. 124 ABD 25 T
3. 125 ABC 123 P
4. 126 ABB 740 T
5. 127 AAB 740 T
6. 128 ABC 123 T
7. 129 ABD 25 T
8. 130 ABB 740 T
when i run select i should get :
records
1. 123 ABC 123 P
3. 125 ABC 123 P
4. 126 ABB 740 T
8. 130 ABB 740 T
where matching criteria is Fund / Amount / Type
I've tried GROUP and COUNT but dont seem to be able to get these
results ?
Any help much appreciated.
Nick
1 table: tbl_tmp
consists of records (trades)
i want to select all rows where data in certain fields are duplicated.
ie.
id. trnNum fund amt type
1. 123 ABC 123 P
2. 124 ABD 25 T
3. 125 ABC 123 P
4. 126 ABB 740 T
5. 127 AAB 740 T
6. 128 ABC 123 T
7. 129 ABD 25 T
8. 130 ABB 740 T
when i run select i should get :
records
1. 123 ABC 123 P
3. 125 ABC 123 P
4. 126 ABB 740 T
8. 130 ABB 740 T
where matching criteria is Fund / Amount / Type
I've tried GROUP and COUNT but dont seem to be able to get these
results ?
Any help much appreciated.
Nick