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
- 4697 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 a subquery in oracle?
what is the syntax of DROP command?
List out the components of logical database structure of oracle database.
Please explain the difference between outer join and inner join? With examples would be appreciable..!
How to resolve name conflicts between variables and columns?
Briefly explain what is literal? Give an example where it can be used?
Explain the use of online redo log files in oracle.
Please explain oracle left join with an example?
Why do you create or replace procedures rather that drop and recreate.
what is data independence exactly? give an example
how to clone 9i Database on to 10g Database.
What is parameterized cursor in oracle?
Oracle General 
