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
- 4614 Views
- I also Faced
- E-Mail Answers
Answer Posted / apsar
select * from tal_name where rownum<=1 order by c desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is an index associated with a constraint?
Explain the use of full option in exp command.
How to estimate disk space needed for an export job?
Explain the use of consistent option in exp command.
What is a select query statement in oracle?
Is a rollback possible to any savepoint?
What is enter substitution variable in oracle?
How to delete an existing row from a table in oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What are the components of logical database structure in oracle database?
What are the different editions of oracle?
How to set up autotrace for a user account?
What is tns name?
What is the usage of save points in oracle database?
