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
What is the usage of merge statement?
How do you store pictures in a database?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to install oracle odbc drivers?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is the difference between alert log file and tarce file ?
Explain about functional dependency and its relation with table design?
How can we find out the duplicate values in an oracle table?
How to sort the query output in oracle?
How to run create database statement?
How to define an explicit cursor in oracle?
How to do a full database export?
what are bitmap indexes? How does they work?
When do you get a .pll extension in oracle?
What suggestions do you have to reduce the network traffic?