From the following table, write a SQL query to find the details of all employees whose last name is ‘Dosni’ or ‘Mardy’. Return emp_idno,

hamza

Save to bookmark

2022-05-18

314

From the following table, write a SQL query to find the details of all employees whose last name is ‘Dosni’ or ‘Mardy’. 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_lname ='Dosni' OR emp_lname= 'Mardy';

Output of the Query:

emp_idno	emp_fname	emp_lname	emp_dept
444527		Joseph		Dosni		47
539569		George		Mardy		27

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 details of all employees whose last name is ‘Dosni’ or ‘Mardy’. Return emp_idno,

All Answers

Similar questions

need a help?

find thousands of online teachers now