How to Select second Maximum salary in a Table ?
Answer Posted / 9896012055
select * salary from table < select max(salary) from table
order by salary;
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is SQL access advisor in Oracle?
Can multiple cursors being opened at the same time?
How does Oracle guarantee data integrity of data changes?
What is the difference between Delete, Truncate and Drop in Oracle?
What is the use of file param in imp command?
definition of cluster and non-clustered index?
How does one get the view definition of fixed views/tables?
How to load data through external tables?
What is null value in oracle?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What is analyze command used for?
How to define an anonymous procedure with variables?
What are the general rules on data consistency?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is java oracle used for?