Re: SQL help needed

j reed wrote:

> demo: show the name of the employee, together with the department and
> number of vacations (er, i mean business trips) of the person who has
> taken the largest number of business trips within each department

Looks a lot simpler using RANK.

http://www.psoug.org/reference/rank.html

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)