Interested to Buy Any Domain ? << Click Here >> for more details...
1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.
- 6 Answers
- 8639 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
select top(2) sal from emp where sal order by desc
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How to define an external table with a text file?
interview questions with answer for cts
How to create a new tablespace in oracle?
Whether any commands are used for months calculation? If so, what are they?
Describe an oracle table?
What do you mean by a database transaction & what all tcl statements are available in oracle?
How to add another datafile to a tablespace?
What are the uses of Database Trigger ?
Explain the use of parfile option in exp command.
How a tablespace is related to data files?
What is bulk load in oracle?
What is SQL Tuning Advisor in Oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What are the attributes that are found in a cursor?
How to convert a date to char in oracle? Give one example.
