Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Suppose,i have one table named competency_details which has one column named competency_value and column contains 200,345,455 and 100
What will be the output of below query?
Select Avg(competency_value) as 'Total Competency' from competency_details;
on 1/22/2014 | Category:
Sql Server Interview questions
| Views: 1875 |
Select from following answers:
Output would be 275.Because Avg function will calculate the Average of the column values and produce output.
So here it will calculate Average as (200+345+455+100)/4 = 275
Show Correct Answer
Many Interviews |
< Previous :
How to save data entered from front-end into a pdf ...
Next > :
What is the meaning of the following query? Selec ...
Comments or Responses
Login to post response
More Interview Questions by Rajesh_Kumar
Suppose,i have one table named competency_details which has one column ...
How to calculate column values in Sql-Server?
What will happen when we execute below query? select avg('123 ...
What is the use of Avg function in Sql-Server?
How to get values from Enum?
Give an example of Len function.
What is the use of Len function in Sql Server?
Latest Interview Questions
What is the meaning of the following query? Select EnrollmentDate, Co ...
What is the output of the following qury? SELECT EnrollmentDate, CO ...
What is the output of the following query? SELECT EnrollmentDate, COU ...
Which of the following statement is correct with respect to garbage co ...
Which of the following statement is correct with respect to Common Lan ...
What are the option statements that are supported in vb.net?
What is hiding and shadowing?
What is the use of DQS?