How to get second highest salary from a table

Answer Posted / senthil

select max(sal) from emp where sal <(select max(sal) from emp)

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a recursive stored procedure?

621


How is data stored on a disk?

549


Is sql better than access?

546


Is sql a programming?

550


How do you write a subquery?

527






What is flag in sql?

547


Why having clause is used in sql?

549


How do you update f as m and m as f from the below table testtable?

1096


What is a delimiter in sas?

550


What does closing a cursor do?

770


What mean sql?

585


How can you fetch first 5 characters of the string?

558


What is an escape character in sql?

571


What are tables and fields?

597


what are the differences between binary and varbinary? : Sql dba

535