Select employee details of dept number 10 or 30

0 votes

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

DeptNo

Mgr

1001

Sachin

19000

1-Jan-1980

2100

20

1003

1002

Kapil

15000

1-Jan-1970

2300

10

1003

1003

Stefen

12000

1-Jan-1990

500

20

1007

1004

Williams

9000

1-Jan-2001

NULL

30

1007

1005

John

5000

1-Jan-2005

NULL

30

1006

1006

Dravid

19000

1-Jan-1985

2400

10

1007

1007

Martin

21000

1-Jan-2000

1040

NULL

NULL

Feb 12, 2023 in Database by Nischitha

edited Mar 4 3 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP