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
4785 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 the difference between postgresql and oracle?

1101

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)

2383

Difference between hot backup vs. Cold backup?

1036

State some uses of redo log files?

1064

How to increment dates by 1 in oracle?

1133

What is the disadvantage of User defind function?

2340

What are the most common interview questions on ETL Testing for experience?

1189

How to select some columns from a table in oracle?

1168

How can I get column names from a table in oracle?

1099

What are the database administrators utilities available?

1091

How do we create privileges in oracle?

1097

What is the usage of save points in oracle database?

1011

Â What are the oracle DML commands possible through an update strategy?

1101

What are the different types of database objects?

1114

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4230