By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,483 Members | 1,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,483 IT Pros & Developers. It's quick & easy.

how to get the previous record value in the current record plz help me...

P: 1
In my sql how to get the previous record value...
in table i m having the field called Date i want find the difference b/w 2nd record date value with first record date... plz any one help me to know this i m waiting for ur reply....

Thanx in Advance
with regards
kotresh
Aug 27 '07 #1
Share this Question
Share on Google+
1 Reply


10K+
P: 13,264
In my sql how to get the previous record value...
in table i m having the field called Date i want find the difference b/w 2nd record date value with first record date... plz any one help me to know this i m waiting for ur reply....

Thanx in Advance
with regards
kotresh
Expand|Select|Wrap|Line Numbers
  1. select theDate from tableName limit 1
  2.  
will give the date for the first record. To navigate between records you can use limit start, stop where start and stop are the offsets.
Aug 27 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.