Abdu Rafeeq

Abdu Rafeeq

  • NA
  • 113
  • 260k

How to get next row value

Aug 2 2011 2:04 AM

 During selection how to find next row value .
 
Ex:
 Some selected rows given beloW
 SlNo Bil No  Date Product Touch  Amout  Wt 
 1  BT-60   01/08/2011  Chain  91.60 200.00  5.000 
 2  BT-61  01/08/2011  Necklase 91.60 100.00  6.000 


I want only any column value  ex:

Bil  No
BT-61 

I want select  a second row  value duing in first row

pls help me



sir

in  select query can select next row  value

means tthat

during first selection got
 1  BT-60   01/08/2011  Chain  91.60 200.00  5.000 

at this time  i want one more filed  value which is next selection column value

NextBIllNO
BT-61 

Lastly i want this type of answer

 SlNo Bil No     Date         Product Touch    Amout   Wt       NextBIllNO     
 1     BT-60   01/08/2011  Chain   91.60    200.00  5.000     BT-61 



Answers (4)