You have a database that has a productdetails table containing more than one rows for each product. each product assigned an productId to identify product. you excute the following query against above table:

select productid,sum(price)as total
from productdetails
group by productid
order by total desc
offset 0 rows fetch next 10 rows only

 Posted by Rajkatie on 1/20/2015 | Category: Sql Server Interview questions | Views: 1084 | Points: 40
Select from following answers:
  1. Get first 10 rows
  2. Get 10 rows with highest total
  3. Syntax error because order by clause is incorrect
  4. All Above

Show Correct Answer

| Alert Moderator 

Comments or Responses

Login to post response