Select Query:

select * from product where unit_price > 1000 and unit_price < 5000;


Output:

PROD_N    DESCRIPTION   UNIT_PRICE    QTY_ON_HAND    CATEGORY
------ ---------------- -----------   -----------  ---------
0001       xxx                        3000           4     A
0002       xxx                        2000           1     B
0003       yyy                        1500           3     A
0004       zzz                        2300           2     C

Leave a Reply

Subscribe to Posts | Subscribe to Comments

All Notes on BCA

All Notes  on BCA
BCA all subjects notes

Total Pageviews

Translate

Powered by Blogger.

Copyright © All Notes on BCA