select top 10 * from comments1 where user='bob' order by com_id DESC

John Rowan (10/21/2010)

---

Your Primary Key should uniquely identify each row. I think you are confusing Primary Key with Clustered Index. You are using the IDENTITY property for your...