Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
What is the output of the following qury?
SELECT EnrollmentDate, COUNT(*) AS StudentCount
WHERE EnrollmentDate IS NOT NULL
on 1/22/2014 | Category:
LINQ Interview questions
| Views: 8490 |
Select from following answers:
When the above query is run, you get the following error:
Column 'Person.EnrollmentDate' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Because it requires a groupBy or an Aggregate function clause as you are performing Count.
Show Correct Answer
Many Interviews |
< Previous :
What is the meaning of the following query? Selec ...
Next > :
What is the output of the following query? SELECT ...
Comments or Responses
Login to post response
More Interview Questions by Kmandapalli
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?
What is the use of nullif function?
Is there any difference between Primary Key and Unique key with not nu ...
Latest Interview Questions
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?