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 |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2012-03-07 : 01:36:00
|
| How to exclude the x lowest numbers from a group of numbersis there a simple function to do that----------------------------------I have a grade book in sql that implements categories i.e table assessment(sectionid,assessmentid, categoryid, maxpoint)table assessmentpoint (assessmentid,studentid,score)table sectioncategory (sectionid,categoryid, weight, droplowest) if droplowest is x how can i drop x lowest grades of that category.is there a function similar to small in excelThankssarah |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-07 : 21:37:53
|
| what do you mean by drop? does it mean excluding from table altogether or is it just excluding from select?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
drop x lowest grades in sql