Re: SQL question

[Quoted] Thanks to everyone for helping.

[Quoted] I tried this but it doesn't like the 'order by' in the embedded select.

I've tried this:-
[Quoted] select * from (select dept, name, salary from employees) where rownum < 4 and dept='1'
order by salary desc;

but it just gives me the first three records, not the top three for each department.

I'm still working on. If it helps, here's the test data:-

CREATE TABLE employees
(Dept NUMBER,
 Name VARCHAR2(20),
 Salary NUMBER);
INSERT INTO employees
VALUES (1, 'Smith', 1000);
INSERT INTO employees
VALUES (1, 'Jones', 2000);
INSERT INTO employees
VALUES (1, 'White', 1000);
INSERT INTO employees
VALUES (1, 'Black', 3000);
INSERT INTO employees
VALUES (1, 'Red', 1000);
INSERT INTO employees
VALUES (1, 'Blue', 1000);
INSERT INTO employees
VALUES (1, 'Smith', 5000);
INSERT INTO employees
VALUES (2, 'Apple', 1000);
INSERT INTO employees
VALUES (2, 'Pear', 3000);
INSERT INTO employees
VALUES (2, 'Peach', 1000);
INSERT INTO employees
VALUES (2, 'Lemon', 4000);
INSERT INTO employees
VALUES (2, 'Melon', 2000);
INSERT INTO employees
VALUES (2, 'Peach', 3000);
INSERT INTO employees
VALUES (2, 'Prune', 1000);

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 02 2000 - 18:14:12 CET