Interested to Buy Any Domain ? << Click Here >> for more details...
25. Display the client number and the value of the highest
value order placed by that client.
- 2 Answers
- 5525 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / uday shankar chejerla
select clientnum,high_value_order from ordertab where
high_value_order=(select max(high_value_order) from
ordertab);
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is a user account in oracle?
Explain do view contain data?
Differentiate between pre-select and pre-query?
What privilege is needed for a user to connect to oracle server?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What is a synonym? What are its various types?
How to speed up webrick?
What are the types of trigger in oracle?
What is a server parameter file in oracle?
How to divide query output into groups in oracle?
How to define a cusotmer as a supplier in ORACLE R12
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 a Nested Loop join?
What are a query and state the different types of queries and their uses?
How to store pictures on to the database?
