Select Query
select order_no,client_no, salesman_no from order_t5  
where client_no in(select client_no from(select client_no,
count(salesman_no) from order_t5 group by client_no having
count(salesman_no)>1));

Output
no rows selected

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