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 |
|
Ndidiamaka
Starting Member
9 Posts |
 Posted - 2010-11-11 : 00:54:04
|
| How can i split students into "quintiles" then calculate the scores like (top 20%, next 20%, middle 20%, next 20%, bottom 20%)the table looks like this;id stdname score--- ------- -----1 ad 802 os 203 yu 354 ed 055 ik 196 yl 687 lp 448 sc 529 pl 1710 mo 77 |
|
|
|
|
|
percentile