Home » RDBMS Server » Server Administration » Finding the common records
- Finding the common records [message #372052] Mon, 08 January 2001 01:04
vijaya kumar
Messages: 3
Registered: January 2001
Junior Member
I have table by name Previleges as follows with two columns viz., Supplier and Service and is stored as follows

Privilege Table
------------------------
Supplier Service
------------------------
Sup1��� login
sup1��� home
sup1��� mypage
Sup2��� login
sup2��� home
Sup3��� login
sup3��� mypage

Could you please formulate SQL Query in order to retrieve the list of Services common to all the three(or what ever no. of i select dynamically) suppliers.

Thanking You and awaiting for your immediate response,

Regards,
Vijaya Kumar
Previous Topic: ORA: 06512 Numeric or Value error
Next Topic: Finding the common records
Goto Forum:
  


Current Time: Sat Jan 11 04:25:17 CST 2025