General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to replace limit amount with zero
Hi all,
I have mytable.dbf contains 3 fields
group limitamount option
AAAAA 1000 YES
AAAAA 2000 NO
AAAAA 3000 NO
AAAAA 4000 NO
BBBBB 5000 NO
CCCCC 6000 NO
DDDDD 7000 YES
DDDDD 8000 NO
EEEEE 9000 NO
FFFFF 2000 NO
How to do select SQL statments in order to have mynewtable.dbf ?
group limitamount option
AAAAA 1000 YES
AAAAA 0 NO
AAAAA 0 NO
AAAAA 0 NO
BBBBB 5000 NO
CCCCC 6000 NO
DDDDD 7000 YES
DDDDD 0 NO
EEEEE 9000 NO
FFFFF 2000 NO
In this above example, we need to replace in group AAAAA 3 records with option = NO and group DDDDD 1 record with option = NO to become zero.
TIA for any help in coding in SQL statments.
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