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
- 3799 Views
- I also Faced
- E-Mail Answers
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
What are advantages of dateset in datastage?
How to create a new table in oracle?
What is primefaces used for?
How would you change old and new values in an insert, delete and update triggers?
How to connect the oracle server as sysdba?
What is the use of oracle?
What is the minimum client footprint required to connect c# to an oracle database?
What is the difference between a primary key & a unique key?
What are group functions in oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
Explain the use of compress option in exp command.
What is the use of file param in imp command?
Is there any function in oracle similar like group_concat of mysql?
Which is faster join or subquery in oracle?
What are temporal data types in oracle?
