title: select max 10 values in sql server 2008
body: <p>i have website of application  which sells applications online.on the home page  i want to  display top 10 products based on number of times they have downloaded.i tried to fetch product ids from sql server database 2008.but the query size increases when i go from high download count value to lower value.because i fetch one product id in one query.so total 10 queries for top 10 applications.</p>
  
  <p>so i want to know whether is there any way to  fetch top 10 applications easily.</p>
  
  <p>i have table named product.It has two fields product_id,purchase_count.i want to get 10 product id who has highest download_count values.</p>