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
- 4710 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 |
When does a Transaction end ?
How to join two tables in a single query using oracle?
What is the function of Optimizer ?
What do you mean by merge in oracle?
What is a deadlock in SQL? How can you prevent it?
sql command 2 know current database
How do I find the database name in oracle?
How to define an oracle sub procedure?
How to define a specific record type?
What is using clause and give example?
why pl sql doesn't support retrieving multiple records
What is Partitions in Table ?
Oracle General 
