Interested to Buy Any Domain ? << Click Here >> for more details...
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
Is the After report trigger fired if the report execution fails ?
How to add a new column to an existing table with a default value?
What is the sid in oracle?
Why do we need integrity constraints in a database?
Why use resource manager in Oracle?
Where are the settings stored for each instance in oracle?
How to define an explicit cursor in oracle?
How to experiment a data lock in oracle?
What is a trigger and what are its types?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
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.
20. Using a set operator, display the client number of all clients who have never placed an order.
State the various uses of dbcc command?
What are the ways tablespaces can be managed and how do they differ?
Explain the use of parfile option in exp command.
