MIN and MAX Query

From: Matty <matt_at_slippeddisk.fsnenegspamt.co.uk>
Date: Wed, 19 Feb 2003 22:08:31 -0000
Message-ID: <b30v6f$i79$1@news7.svr.pol.co.uk>

Hi All

Just starting out making queries with SQL and have become stumped, and am looking for help!

Table is called emp, with the following fields:

EMPNO
ENAME
SAL I need to write a query to show the employees name and salary of the highest and lowest salary earner.

I have worked it out to show the highest and lowest salaries but cannot get it together with the name!!

I would appreciate your help here!

Many thanks in advance

Matty Received on Wed Feb 19 2003 - 16:08:31 CST