Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
janardhana
Starting Member
4 Posts |
 Posted - 2008-06-24 : 11:05:38
|
| Hello friends,plza help meeeeeeee |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-06-24 : 11:11:23
|
| 1 Define Last N-1 records2 Post some sample data with expected resultMadhivananFailing to plan is Planning to fail |
 |
|
|
janardhana
Starting Member
4 Posts |
Posted - 2008-06-24 : 11:17:33
|
| name price---- -----aaa 123.00bbb 125.00ccc 128.25ddd 136.66qqq 156.00ggg 165.45I want last n-1 records,meansccc 128.25ddd 136.66qqq 156.00i want avg of above prices |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-06-24 : 11:21:11
|
| How do you identify that they are last n-1 records?Do you have any other unqiue column in the table?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
How to find avg of last N-1 records in sql?