Find the Less Serial Numbers in a table [message #313048] |
Thu, 10 April 2008 08:56  |
mailtokkalyan
Messages: 65 Registered: December 2006 Location: Bangalore
|
Member |
|
|
Hi ,
I want to retrive the records which are less than the current slno, For example,
Table Name : GRN_HDR
There are 5 Records...
GRN_NO GRN _DATE DC_NO INV_NO DC_DATE
---------------------------------------------
GRN0001 10/03/08 101 05/03/08
GRN0002 10/03/08 101 05/03/08
GRN0003 10/03/08 101 05/03/08
My Current GRN No Is GRN0003...I want to retrive the Previous GRN Numbers...i cannot use min or max...because GRN Number may not be sequence, so should i use rowid? how? Please Tell me..
Thanks,
Kalyan
|
|
|
|
|