SQL help

[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

 

[Ken Slovak - [MVP - Outlook]]

Post your question in a SQL group, this is an Outlook group.