225679/select-employee-details-of-dept-number-10-or-30
Dept Table:
DeptNo
Dname
Loc
10
Accounts
Bangalore
20
IT
Delhi
30
Production
Chennai
40
Sales
Hyd
50
Admn
London
Emp Table:
EmpNo
Ename
Sal
Hire_Date
Commission
Mgr
1001
Sachin
19000
1-Jan-1980
2100
1003
1002
Kapil
15000
1-Jan-1970
2300
Stefen
12000
1-Jan-1990
500
1007
1004
Williams
9000
1-Jan-2001
NULL
1005
John
5000
1-Jan-2005
1006
Dravid
1-Jan-1985
2400
Martin
21000
1-Jan-2000
1040
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.