Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
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
group by productid
order by total desc
offset 0 rows fetch next 10 rows only
on 1/20/2015 | Category:
Sql Server Interview questions
| Views: 1084 |
Select from following answers:
Get first 10 rows
Get 10 rows with highest total
Syntax error because order by clause is incorrect
Group by clause allows us to use aggregate function and perform calculation over rows that have a matching value in column.
The OFFSET-FETCH option is a filtering option like TOP keyword.
Show Correct Answer
< Previous :
When a view definition contains a join
Next > :
which of the following column require to provide a ...
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
which of the following column require to provide a value when you issu ...
You are learning, how to create window 8 store application using html5 ...
Which of the following VS studio versions you can used for create web ...
What is Perfecto Mobile?
What is WebDriver?
What is difference between ASP.NET Web API and WCF?
Your developing web application which access data from a MS sql and ha ...
What is BrowserLink ?
Latest Interview Questions
What is the return type of Ident_Seed function?
What do we mean by Ident_Seed Sql Server Function?
How to check a Local Temporary Tables are present on Database?
How many types of UDFs in Sql Server?
What are the necessary parameters that is required when using RAISEERR ...
How will you consume a WCF Sevice without creating a proxy.
An two interface has got same method names, how can you access differe ...
An interface has got four Interface methods (m1,m2,m3,m4) and implemen ...