> >
> >
> >
> delete from mytable where record_no=? limit ?
>
> Setting the first parameter to the record number and the second to count
> - 1.
>
Ah "limit", yes that should help.
However, I do not know each individual nos for these "record_no"
Can I have sth that will dynamically delete those rec
Manish wrote:
I have got few duplicate record in my DB as follows.-
Let's say record_no is the unique id of duplicate records.
So I have fields ID, record_no , X and Y. (ID is a dif filed and is a
primary key)
To find duplicates I do following -
select record_no,count(record_no) from mytable group
I have got few duplicate record in my DB as follows.-
Let's say record_no is the unique id of duplicate records.
So I have fields ID, record_no , X and Y. (ID is a dif filed and is a
primary key)
To find duplicates I do following -
select record_no,count(record_no) from mytable group by record_n
