How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09

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 / anilchauhan85

2 Answers
4199 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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 orac..

Answer / sivaraman (gasc)

select a,b,c,d,e from tbl_name where c = (select max(c)
from tbl_name)

Is This Answer Correct ?

3 Yes

1 No

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 orac..

Answer / apsar

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle General Interview Questions

How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

2 Answers Infosys,

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

0 Answers TCS,

What is data file?

0 Answers

how to unbreak sequence numbers during intereptions

1 Answers Ion Exchange,

Can we protect our pl/sql source code?

0 Answers

When can Hash Cluster used ?

1 Answers

what is data independence exactly? give an example

6 Answers

what is data abstraction