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_at_news7.svr.pol.co.uk>
[Quoted] Hi All
Date: Wed, 19 Feb 2003 22:08:31 -0000
Message-ID: <b30v6f$i79$1_at_news7.svr.pol.co.uk>
[Quoted] Hi All
[Quoted] [Quoted] Just starting out making queries with SQL and have become stumped, and am [Quoted] 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
[Quoted] and lowest salary earner.
[Quoted] I have worked it out to show the highest and lowest salaries but cannot get [Quoted] it together with the name!!
I would appreciate your help here!
[Quoted] Many thanks in advance
Matty Received on Wed Feb 19 2003 - 23:08:31 CET