Hi
I think this query will help you..
select name, earning,(select min(earning) from customer) as MinEarning,
(select max(earning) from customer) as MaxEarning from customer where earning in
( (select min(earning) from customer) ,
(select max(earning) from customer))
Aswathi Narayan