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));
no rows selected
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));
no rows selected
Copyright © All Notes on BCA