Query:


SELECT * FROM sales_mans_t5 s WHERE s.salesman_name like 'a%' and 
EXISTS (SELECT * FROM order_t5 o WHERE o.salesman_no = s.salesman_no);


Output:

SALESM SALESMAN_NAME ADDRESS   CITY  STATE  PINCODE   SAL_AMT	
------ ------------- --------- ----- ------ --------- --------
s00004 ashish       A/5 jahu   bombay  Mah  400044       7000

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