Answer Posted / anandh
select * from emp where sal = (select max(sal) from emp where sal<>(select max(sal) from emp));
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the difference between a primary key & a unique key?
What do you understand by a database object? Can you list a few of them?
How to turn on or off recycle bin for the session?
What happens if you use a wrong connect identifier?
What is concurrency in oracle?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to handle a single quote in oracle sql?
What is clustered table in Oracle?
What are the common oracle dba tasks?
What is open database communication (odbc) in oracle?
Can group functions be mixed with non-group selection fields?
How to start your 10g xe server?
What are ddl statements in oracle?
How to create a new table by selecting rows from another table?
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.