SQL help

  • Thread starter Thread starter safs
  • Start date Start date
S

safs

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
 
Back
Top