Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4791 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 |
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How can we Update a table with out using UPDATE command?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to convert a string to a date in oracle database?
When a form is invoked with call_form, Does oracle forms issues a save point ?
What is oracle rowcount?
What are the set operators union, union all, minus & intersect meant to do?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
What is a proxy object?
Explain the use of rows option in imp command.
How do we switch from init.ora file to asp file?
Explain how you would restore a database using RMAN to Point in Time?
Oracle General 
