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
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How to test null values?
what is the difference between data migration and production migration.
How to use windows user to connect to the server?
Explain compound trigger in oracle?
How to turn on or off recycle bin for the session?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is max rowid in oracle?
What do you mean by redo log file mirroring?
Does facebook use oracle?
How to speed up webrick?
How to open and close an explicit cursor in oracle?
What is transport network substrate (tns) in oracle?
What are the ways tablespaces can be managed and how do they differ?