Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

selecting single record from multiple record based on date

ThejAug 26 2013 — edited Aug 26 2013

Hi experts,

I have a table which contains the multiple records for single ID No. Now i have to select single record which contains the latest date.

here is the structure

Name   Null Type        

------ ---- ------------

ID_P        NUMBER      

NAME_P      VARCHAR2(12)

DATE_P      TIMESTAMP(6)

Records

---------------------

1 loosi     22-AUG-13 01.27.48.000000000 PM

1 nammi  26-AUG-13 01.28.10.000000000 PM

2 kk        22-AUG-13 01.28.26.000000000 PM

2 thej      26-AUG-13 01.28.42.000000000 PM

now i have to select below 2 rows how can write select qurie for this?

1 loosi     26-AUG-13 01.27.48.000000000 PM

2 thej      26-AUG-13 01.28.42.000000000 PM
This post has been answered by Frank Kulash on Aug 26 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 23 2013
Added on Aug 26 2013
4 comments
381 views