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
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 |
How to define a procedure inside another procedure?
Explain alias?
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.
Indexes in oracle ?
3 Answers Keane India Ltd, L&T,
Explain rename?
How do I call oracle stored procedures that take no parameters?
Does a Before form trigger fire when the parameter form is suppressed ?
How to connect asp pages to oracle servers?
Explain parameter file in oracle.
Which is better Oracle or MS SQL? Why?
When does a Transaction end ?
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)