How to Select second Maximum salary in a Table ?
Answer Posted / havyas
select sal from table where rownum = 2 order by sal desc
| Is This Answer Correct ? | 1 Yes | 13 No |
Post New Answer View All Answers
types of indexes and the rationale behind choosing a particular index for a situation.
What is merge statement used for?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How to best split csv strings in oracle 9i?
How to get a create statement for an existing table?
What are the system predefined user roles?
What is java oracle used for?
How does one get the view definition of fixed views/tables?
Explain what are synonyms used for?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How to execute a stored procedure in oracle?
definition of cluster and non-clustered index?
Explain oracle’s server parameter file.
How to turn on or off recycle bin for the session?
What is a tns file?