Consider the following table named Employee.
Field Name
Data Type
Size
Remark
Empid
Number
5
Primary Key
FName
Varchar
20
Mname
Varchar
20
SName
Varchar
20
Dno
Varchar
5
Should start with character ‘D’
DOB
Date
Should not take null value
DOJ
Date
Should not take null value & Should later than Date Of Birth
Salary
Number
7
Should take only +ve value
City
Varchar
15
Should not take null value & values should take metro names
a) Create the above table
b) List out the dates on which employees joined.
c) List out department wise the maximum salary and average salary given
d) Display empid and name of all the employees.( Note – name should be displayed in the format R.S.Mishra)
e) Display how many employees are there.
f) Display the department numbers
g) Display empid, employee name, date of birth and date of joining of all the employees.(Note – date of birth should be in the format dd/mm/yy and date of joining should be in the format dd/month/yyyy).
h) Display names of those employees whose salary is between 15000 and 25000.
Answers
Answered by
0
Answer:
sorry for the earning points by your question.
Answered by
1
mate sorry but...l can't understand
Similar questions