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
- 4786 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 |
What is the function of Optimizer ?
How to use like conditions in oracle?
When do we use group by clause in a sql query?
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
Does oracle charge for java?
How to recover a dropped index?
Where are the settings stored for each instance in oracle?
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
Why do we need oracle client?
What is the database name in oracle?
what is pragma?
How to change user password in oracle?
Oracle General 
