What will be the output of the fallowing SELECT statement?SELECT count(*)FROM empWhere exist (select 'X' From deptwhere dept_name ='Stores' and dept.dept_id=emp.dept_id)A. select total number of employees belonging to department " stores "B. select all employees belonging to department "X"C. select all employees belonging to department "stores"D. select total number of employees belonging to department "X"

krishna

• Aug 11th, 2005

 

A. It selects the total no of emplyoyees in stores

NAGA

• Aug 29th, 2006

 

This will not give any output

This will throw a error missing expression