Query:


SELECT cust_no, no_of_items_purchased, total_Price  FROM 
cust_prod_t5 WHERE no_of_items_purchased > 5;


Output:
CUST_N NO_OF_ITEMS_PURCHASED TOTAL_PRICE
------ --------------------- -----------
001                       50        5000
002                       30        3000
003                       50        5000
004                       60       15000
005                       10       12000

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