Home » SQL & PL/SQL » SQL & PL/SQL » Re: To Retrieve a single row ; Urgent
Re: To Retrieve a single row ; Urgent [message #21235] Fri, 19 July 2002 02:04
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
if you are looking an output based on max(rep_status_dt) , then
1. use rownum < 2. to guarantee the use orderby alongwith.
2. else add a where condition like

and rep_status_dt = ( select max(rep_status_dt) from table_name);

Report message to a moderator

Previous Topic: Help with Alter Tablespace !!!
Next Topic: very urgent
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 10:42:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.