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
4578 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 do you mean by cdb and pdb in oracle 12c?

1006

Can we convert a date to char in oracle and if so, what would be the syntax?

956

Differentiate between pre-select and pre-query?

1052

Why do you create or replace procedures rather that drop and recreate.

945

What is a cursor in oracle?

1106

What is a table index in oracle?

1066

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2063

Please explain joins in oracle?

1007

How to pass a cursor variable to a procedure?

1039

Can multiple columns be used in group by in oracle?

926

What is the relation of a user account and a schema in oracle?

1006

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

2683

How to create a stored procedure in oracle?

1026

How to work with data objects interactively?

924

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

973