find out the second highest salary?

Answer Posted / digvijay

select max(salary) from emp where salary < Top Salary

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use in conditions in oracle?

556


How a tablespace is related to data files?

583


What is the difference between substr and instr?

519


Explain the use of tables option in exp command.

591


candidate key is subset of super key but not vice-verse explain

1579






What privilege is needed for a user to insert rows to tables in another schema?

560


IS it possible to built the oracle database without setting the kernal parameters?

1761


How can we find out the duplicate values in an oracle table?

608


What is blob data type in oracle?

559


How to rename an index?

588


What is meant by joins?

621


What is snapshot is too old? Give and example for better understand.

1100


What is analyze command used for?

580


Is rowid unique in oracle?

528


What is a table index in oracle?

632