What is the meaning of the following query?
Select EnrollmentDate, Count(*) AS StudentCount
From TableName
GROUPBY EnrollmentDate

 Posted by Kmandapalli on 1/22/2014 | Category: LINQ Interview questions | Views: 3464 | Points: 40

The AS clause holds the column name that you want to give.
Hence in the result, the column name for the count will be StudentCount whereas if you dont specify the AS clause then in the result it shows No column name because this column(Count) doe not exist in your database.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response