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
Answer Posted / apsar
select * from tal_name where rownum<=1 order by c desc
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we find out the duplicate values in an oracle table?
What is a trigger oracle?
Is there a combination of "like" and "in" in sql?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What happens to indexes if you drop a table?
Who developed oracle & when?
What is bulk load in oracle?
Explain the blob datatype?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is an anonymous block?
What are data pump export and import modes?
What is the order of defining local variables and sub procedures/functions?
What is pragma autonomous transaction in oracle?
what are bitmap indexes? How does they work?
How to declare a local variable?