Thread: SQL help
View Single Post
  #1  
Old November 21st, 2006, 12:27 PM posted to microsoft.public.outlook.contacts
safs
external usenet poster
 
Posts: 13
Default SQL help

Create table Employee
Name varchar(10)
Empno where the employee no must be in varchar(XXXNumeric)first three
must be in depart no and other must be in auto number using roll
Age char(2)
Salary currency
Depname default is admin
Manager code varchar(10)

Department
DNo number
Department name
Description

Find which department is having height salary
Find which department manager gets high salary
Summary reports of each department by average age, salary, total exp