The discount table contains the discount type, store id, quantity, and percentage discount of discounts in the pubs3 database.
discounts is defined as follows:
create table discounts (discounttype varchar(40) not null, stor_id char(4) null references stores(stor_id), lowqty smallint null, highqty smallint null, discount float not null)
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
