How to get first record of each item only ?

hi,

>From below table want only the first value of each item id.
and how to get it, tried to use top n function in select statement it takes only the first record.

itemid qty

  1       10
  1        5
  1       15
  2       20
  2       15
  4       10
  4        5
  4        2

Please help.

captain Received on Thu Apr 21 2005 - 11:08:58 CDT