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, 2025 321 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