Answer Posted / mk
select *from emp where sal=(select distinct(max(sal)) from
emp where sal <select max(sal) from emp )
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is Java Pool in Oracle?
How to login to the server without an instance?
Name the three major set of files on disk that compose a database in Oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What is Undo Management Advisor in Oracle?
What are the ways tablespaces can be managed and how do they differ?
What are the different types of database objects?
What are the uses of Database Trigger ?
What is an external table?
List out the difference between commit, rollback, and savepoint?
What is meant by joins?
What is archive log in Oracle?
What is the difference between truncate & delete command?
How to change program global area (pga) in oracle?
Explain integrity constraints?