Pull second record of an ordered set.... 1

[flaniganmj]

Howdy,

How can I pull (SQL) the second record of an ordered set? Example:

Vendor Invoice No
1 1
1 2
1 3
2 4
2 5
2 6

I need have return something like this:

Vendor Invoice No
1 2
2 5

Any help?

flan

 

[swampBoogie]

select vendor,Min(InvoiceNo)
  from t as q
 where invoiceNo > (select min(invocieNo) from t
  where vendor = q.vendor)
 group by vendor

 

[flaniganmj]

Thank you!