TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Abdu Rafeeq
NA
113
264.7k
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
Reply
Answers (
4
)
How to add child table rows as columns to the parent table?
Decimal , Float