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
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How to add a new column to an existing table with a default value?
What are the restrictions in a oracle read only transaction?
What is integrity and what is constraint??Explain with example
Explain oracle data types with examples?
Is the After report trigger fired if the report execution fails ?
How to create a testing table in oracle?
What are the logical operations?
How to use regular expression in pattern match conditions in oracle?
Difference between pre-select and pre-query
Explain what are the uses of rollback segment?
What is control file used for?
How to concatenate two text values in oracle?
What is an oracle and why it is used?
What is difference between sid and service name in oracle?