Posted by: smoothcriminal January 6, 2009
SQL Guff
Login in to Rate this Post:     0       ?        

1)  Select  t.ItemList from


     (Select Rownumber( ) over (order by ItemList desc) as Seq, Itemlist from table)t


     Where t.seq =3

Read Full Discussion Thread for this article