Home » SQL & PL/SQL » SQL & PL/SQL » To Retrieve a single row ; Urgent
To Retrieve a single row ; Urgent [message #21229] Thu, 18 July 2002 21:10 Go to next message
Debasish Sanyal
Messages: 1
Registered: July 2002
Junior Member
Dear All ,

I have a select statement like this :
select a.con_no,rep_status_dt,flag from ast_ppl a , ast_rep b
where a.con_no= b.con_no
It gives this output :
a.Con_no Rep_status_dt Flag
456237 18-JUN-02 RP
456237 12-JUN-02 SL

Rep_status_dt and Flag are only in ast_rep

I want only one row from above output depending on
max(rep_status_dt) by modifying the above query .

So Pls help

Regards
Debasish

Report message to a moderator

Re: To Retrieve a single row ; Urgent [message #21262 is a reply to message #21229] Sun, 21 July 2002 22:59 Go to previous message
Surya
Messages: 34
Registered: December 2001
Member
why do you need only one result. Both the result shown above are different.

Report message to a moderator

Previous Topic: check out please
Next Topic: Oracle User Defined Function
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 13:30:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.