SQL help needed

From: AJ Benn <a.j.benn_at_x400.icl.co.uk>
Date: Mon, 28 Sep 1998 16:09:49 +0100
Message-ID: <360fa584.0@145.227.194.253>

Using the Oracle example table 'EMP', I want to produce a query that will show me the number of employees whose Salary falls within a particular range
(i.e less than 1000, between 1000 and 3000, and then greater than 3000), and
then grouped by Job. The output I want is as follows:-

Job                   $ <1000              $ 1000-3000             $ 3000+
=======            ====                ========               =====
Clerk                    2                        2
Salesman                                       4
Manager                                         3
Analyst                                          2

President
1

Anyone offer any help on this knotty little problem ?

Many thanks
Andy

(Sorry if the table isn't lined up very well)
Received on Mon Sep 28 1998 - 10:09:49 CDT