SQL group by a range?
From: Neothinker <neo_thinker_at_hotmail.com>
Date: 26 Feb 2002 14:05:14 -0800
Message-ID: <d351ed4f.0202261405.7a3ef902_at_posting.google.com>
Date: 26 Feb 2002 14:05:14 -0800
Message-ID: <d351ed4f.0202261405.7a3ef902_at_posting.google.com>
I am trying to create a query that will tally the number of students with a grade from 90 to 100, 80 to 89, 70 to 79 ,... etc. So if I have a table that just had a "STUDENT" column and a "GRADE" column, what generic SQL could I use? As far as I know, the GROUP BY only accepts a column name, not an expression. Received on Tue Feb 26 2002 - 23:05:14 CET