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
4707 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 control file used for?

1220

How to pass a cursor variable to a procedure?

1115

What is a private synonym?

1593

How to use windows user to connect to the server?

992

What is blob data type in oracle?

1128

What is a server parameter file in oracle?

1063

What is the exact use of Collections?

2145

How to pass parameters to procedures?

1041

How to run queries on external tables?

1055

Can we store pictures in the database and if so, how it can be done?

1047

What is rich query?

989

Where is the export dump file located?

1166

How to connect the oracle server as sysdba?

1087

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1427

How to retrieve data from an explicit cursor?

1066