General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Delete duplicate records
Dear Experts,
Table1 has three fields as
date---------d(8)
voucher-----n(4)
type---------c(2)
data in table is as follows
25/11/06----1----SL
25/11/06----1----SL
25/11/06----2----SL
25/11/06----2----SL
25/11/06----2----SL
25/11/06----1----SD
25/11/06----1----SD
25/11/06----1----SD
I want to delete more than two records according to following index file
select table1
index on dtoc(date)+str(voucher)+allltrim(type) to xyz
after processing the data in table should look like this
25/11/06----1----SL
25/11/06----1----SL
25/11/06----2----SL
25/11/06----2----SL
25/11/06----1----SD
25/11/06----1----SD
The number of same records is two.
Please help
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only