Mensaje
De
03/06/2008 13:08:04
a
03/06/2008 13:03:00
General information
Foro:
Visual FoxPro
Category:
Programación, sintáxis y comandos
Título:
Miscellaneous
ID de la conversación:
01321346
ID del mensaje:
01321347
Views:
14
What is the definition of a duplicate here?
>I have a table with this structure:
>
>
>How do I remove the duplicate rows?
>I have a table with this structure:
>
>
>Sec Tp Title Table Field >--------------------------------------------------------- > CR cash balance between 300.rpt trades tradedate > CR cash balance between 300.rpt trades valuedate > CR cash balance between 300.rpt cust acctname > CR cash balance between 300.rpt trades conf_num > CR cash balance between 300.rpt trades product > CR cash balance between 300.rpt trades quantity > CR cash balance between 300.rpt trades price > CR cash balance between 300.rpt trades ext_price > CR cash balance between 300.rpt trades productbal > CR cash balance between 300.rpt trades cash_bal >3.1 CR invoice prior posting.rpt trades product >3.1 CR invoice prior posting.rpt trades quantity >3.1 CR invoice prior posting.rpt tranfile tranquant >3.1 CR invoice prior posting.rpt prods prodesc >3.1 CR invoice prior posting.rpt trades price >3.2 CR open customer positions.rpt trades tradedate >3.2 CR open customer positions.rpt trades tradetype >3.2 CR open customer positions.rpt trades product >3.2 CR open customer positions.rpt trades quantity >3.2 CR open customer positions.rpt trades price >3.2 CR open customer positions.rpt trades net_amount >3.2 CR open customer positions.rpt trades cash_bal >3.2 CR open customer positions.rpt trades conf_num >3.2 CR open customer positions.rpt trades productbal >3.2 CR open customer positions.rpt trades valuedate >>
>How do I remove the duplicate rows?