select * from tal_name where rownum<=1 order by c desc

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

Question Posted / apsar

2 Answers
4695 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

Please Help Members By Posting Answers For Below Questions

How many types of auditing in Oracle?

1035

What is a package ? What are the advantages of package ?

1091

What do you mean by redo log file mirroring?

1032

How can we force the database to use the user specified rollback segment?

1148

How do we create privileges in oracle?

1047

what is the difference between functional dependecy and multilevel dependency?

2462

why dont we assign not null constraint as table level constraint.

2739

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2185

Explain about achiever in sql?

1040

What is SQL Tuning Advisor in Oracle?

1181

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1729

What is the difference between formal parameters and actual parameters?

1089

How do we represent comments in oracle?

1048

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1147

How to login to the server without an instance?

1162