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
- 4700 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 |
acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account
How to get a list of all user accounts in the database?
How to increment dates by 1 in oracle?
What would you do with an in-doubt distributed transaction?
How to speed up webrick?
Explain the function of optimizer in oracle?
How to insert multiple rows with one insert statement in oracle?
What are the ways tablespaces can be managed and how do they differ?
What is a materialised view?
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
What are the roles of dba?
Explain the use of online redo log files in oracle.
Oracle General 
