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
4656 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

What is a initialization parameter file in oracle?

1018

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1068

What are triggers in oracle?

1009

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2303

What are the original export and import utilities?

1136

How to create a server parameter file?

1117

Explain the difference between replace() and translate() functions in oracle?

1020

How to Truncate Table in Oracle

1134

How to use attributes of the implicit cursor in oracle?

983

How to load excel data sheet to oracle database

1003

Are truncate and delete commands same? If so why?

1128

What is primefaces used for?

1035

How does oracle handle read consistency?

1075

How to use regular expression in pattern match conditions in oracle?

1017

How to work with data objects interactively?

958