25. Display the client number and the value of the highest
value order placed by that client.
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 oracle thin client?
Explain oracle 12c new features for developers?
In what script is snap$ created? In what script is the scott/tiger schema created?
How to bring a tablespace offline?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
material view and view disadvantages?
How will you identify oracle database software release?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How to lock and unlock a user account in oracle?
What do database buffers contain?
How to calculate date and time differences in oracle?
How to find the duplicate rows count from employees table in oracle?
How to connect asp pages to oracle servers?
How data locks are respected in oracle?
In the oracle version 9.3.0.5.0, what does each number shows?