how to find the second highest salary from emp table?

Answer Posted / bharath konegadde

Select Emp_Name from emp_table where Id=(Select Emp_Id from Salary Order By salary Desc limit 0,1)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is %isopen always false for an implicit cursor?

578


what are the drivers in mysql? : Sql dba

572


What is compilation error in pl sql?

515


Could you please provide oca (oracle 10g) dumps for my certification ?

4523


Can we rollback delete command?

517






What is int identity in sql?

580


What are the different dml commands in sql?

595


What is PL/SQL Records?

640


What is a memo field?

539


How do I create a sql database?

533


How do you create an update query?

536


give the syntax of grant and revoke commands? : Sql dba

625


Can we commit inside a trigger?

557


Is crud a cuss word?

562


What is lexical units in pl sql?

588