Answer Posted / irshad ahmad
Select max(price) from product where price
not in (select max(price) from product);
Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What are the oracle built-in data types?
How to check database size in Oracle?
What is logical backup in oracle?
Name the three major set of files on disk that compose a database in Oracle?
What are the different editions of oracle?
Query to retrieve record for a many to many relationship ?
How to set up autotrace for a user account?
What are the ansi data types supported in oracle?
Why do we use bulk collect in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to use fetch statement in a loop?
Can we create trigger on materialized view in oracle?
How to write a query with an inner join in oracle?
What is background process in Oracle?