How can return max date row
A b c d e
1 2 1-mar-09 5 10
1 2 10-mar-09 5 10
Only using oracle predefined function. Not user defined.
Output:--
A b c d e
1 2 10-mar-09 5 10
- 2 Answers
- 3782 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sivaraman (gasc)
select a,b,c,d,e from tbl_name where c = (select max(c)
from tbl_name)
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / apsar
select * from tal_name where rownum<=1 order by c desc
| Is This Answer Correct ? | 0 Yes | 0 No |
What is an oracle cursor variable?
What is define in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
Will you be able to store pictures in the database?explain.
When do I need to use a semicolon vs a slash in oracle sql?
How to open a cursor variable?
hai, when to use char and varchar2....?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What privilege is needed for a user to connect to oracle server?
How to export your connection information to a file?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
Use of an integrity constraint is better to validate data. Explain
Oracle General 
