Select Query:


select * from product where unit_price > 2000;


Output:


PROD_N DESCRIPTION   UNIT_PRICE  QTY_ON_HAND  CATEGORY
------ -------------------- ---------- ----------- ----------
0001   xxx                        3000           4           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