Answer:
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