-
-
How many tables are needed to create and their relationships ?
Supplier Name Supplier Site Supplier Street Supplier Contact Person Supplier City Supplier State Supplier Phone number Business requirement is : One Supplier can have multiple ( n number of Sites ), One Supplier Site can have Multiple Contacts Persons ( n number of Contact persons ), One Supplier Contact Person can have multiple phone numbers ( n number of Phone numbers ) .
-
SQL - Find top two salary for each department
1. top 2 salary in each dept2. 2nd maximum sal in each dept3. 2nd minimum sal in each dept.