Get the second smallest value

[don2241]

Hi!

Imagine having a table with attributes:
s#--p#--j#--qty

How can I get the second smallest value of 'qty'

Thank you
Martin

 

[dickiebird]

Try :-

set rowcount 1
select qty from tablename
where qty > (select min(qty) from tablename )
order by qty

(This suits sybase - your number of output rows may need different control)
;-) Dickie Bird
db@dickiebird.freeserve.co.uk

 

[grega]

Or you could say ...

select min(qty) from table
where qty > (select min(qty) from table)

Greg.

 

[don2241]

Thank you very much.

Martin

 

[barbarul2001]

if you want another solution...

select distinct a.qty from table a
where 1=(select count(*) from table b where a.qty>b.qty)

it works in every dbms i know. web/sql developer