how to find out second largest value in the table

Answer Posted / sudhakara reddy k

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the blob datatype?

697


What is memory advisor in Oracle?

714


What is rowid and rownum in oracle?

628


what is the scenario where you take the database to NoArchivelog mode?

1946


How does one get the view definition of fixed views/tables?

688






Explain constraining triggers.

703


Calculate difference between 2 date / times in oracle sql?

653


What are the different types of modules in oracle forms?

639


How to view existing locks on the database?

643


What are the differences between char and nchar in oracle?

683


How to define a specific record type?

702


Explain how are indexes update?

701


What is a table index?

654


What is merge statement used for?

659


What is the exact use of Collections?

1764