Find out the 3rd highest salary?

Answer Posted / kaushal kassi

select distinct a.sal
from employee a
where 3=(select count(distinct b.sal)
from employee b
where a.sal<=b.sal)

Is This Answer Correct ?    24 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a control file ? : Sql dba

575


What is sql indexing?

552


What is the maximum size of sqlite database?

546


Define a temp table?

551


What are different types of sql commands?

508






What is a unique key?

584


What type of join is sql join?

529


Why do we use sql constraints?

655


Why is %isopen always false for an implicit cursor?

568


What normalization means?

525


what is sql in mysql? : Sql dba

569


Why we use stored procedure instead of query?

533


How do I edit a stored procedure?

552


Is join and inner join the same?

537


what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

615