From the following table, write a SQL query to find the employees who works at depart 47 or 63. Return emp_idno, emp_fname, emp_lname, and emp_dept

hamza

Save to bookmark

2022-05-18

154

-1

From the following table, write a SQL query to find the employees who works at depart 47 or 63. Return emp_idno, emp_fname, emp_lname, and emp_dept.

Sql programming,

All Answers

hamza

2022-05-18

need an explanation for this answer? contact us directly to get an explanation for this answer

SELECT * 
 FROM emp_details
  WHERE emp_dept = 47 OR emp_dept = 63;

Output of the Query:

emp_idno	emp_fname	emp_lname	emp_dept
526689		Carlos		Snares		63
328717		Jhon		Snares		63
444527		Joseph		Dosni		47
659831		Zanifer		Emily		47
748681		Henrey		Gabriel		47
733843		Mario		Saule		63

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

From the following table, write a SQL query to find the employees who works at depart 47 or 63. Return emp_idno, emp_fname, emp_lname, and emp_dept

All Answers

Similar questions

need a help?

find thousands of online teachers now