find out the second highest salary?

Answer Posted / tejinder

select salary from emp order by salary desc limit 0,1;

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1693


How to add a new column to an existing table with a default value?

542


What are the restrictions in a oracle read only transaction?

569


What is integrity and what is constraint??Explain with example

1695


Explain oracle data types with examples?

575






Is the After report trigger fired if the report execution fails ?

2402


How to create a testing table in oracle?

543


What are the logical operations?

674


How to use regular expression in pattern match conditions in oracle?

573


Difference between pre-select and pre-query

574


Explain what are the uses of rollback segment?

580


What is control file used for?

602


How to concatenate two text values in oracle?

590


What is an oracle and why it is used?

623


What is difference between sid and service name in oracle?

516