Answer Posted / ricky
while we are using a aggregate function we use the group by
clause....
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Why I can not enter 0.001 second in date and time literals in ms sql server?
What are system databases into sql server (2005/2008) : sql server database administration
What is field with example?
What is normalization and what are the advantages of it?
What factors you will consider calculating the storage requirement for that view?
What are sql servers used for?
What is the difference between varchar and varchar(max) datatypes?
Mention the different types of replication in sql server.
Does index speed up select statements?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What is a transactions?
What is the command dbcc checkdb used for?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Explain left outer join and right outer join?
How to create a view on an existing table in ms sql server?