Query:


SELECT sales_order_no, COUNT(product_no) as Total_Product 
FROM sales_order_t5  GROUP BY sales_order_no;

Output:
SALES_ TOTAL_PRODUCT
------ -------------
o00001             1
o00002             1
o00003             1
o00004             1

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