Which of the following queries is used for displaying least paid employees fname?
select fname from employees where salary=min(salary) ;
select fname,min(salary) from employees ;
declare @min_sal int;
select @min_sal=MIN(salary) from employees ;
select fname from employees where salary=@min_sal ;
None of the above
First query will not work since aggregate functions must not be used in the where clause.
Back To Top