Hi friends
I want to know What is aggregate functions in SQL Server ?
Thank you.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
sameer gadadePosted Jun 15, 2012, 2:06 AM
vipendra
please check it
FROM Pubs.dbo.titles WHERE type <> 'business'
GO
FROM AdventureWorks.HumanResources.Employee;
GO
FROM Pubs.dbo.titles GO
FROM AdventureWorks.HumanResources.Employee;
GO
FROM Pubs.dbo.titles GO
FROM AdventureWorks.HumanResources.Employee;
GO
FROM Pubs.dbo.titles GO
FROM AdventureWorks.HumanResources.Employee;
GO
COUNT - Returns the number of items in the select list as an integer data type including NULL and duplicate values.
FROM Pubs.dbo.titles
GO
FROM AdventureWorks.HumanResources.Employee;
GO
COUNT_BIG - Returns the number of items in the select list as a big integer data type including NULL and duplicate values.
FROM Pubs.dbo.titles GO
FROM AdventureWorks.HumanResources.Employee;
GO
FROM Pubs.dbo.titles WHERE type <> 'business'
GO
FROM AdventureWorks.HumanResources.Employee;
GO
FROM Pubs.dbo.Titles
GROUP BY royalty WITH ROLLUP
GO
FROM AdventureWorks.Sales.SalesPerson
GROUP BY SalesQuota WITH ROLLUP;
GO
FROM Pubs.dbo.titles WHERE type <> 'business'
GO
FROM AdventureWorks.HumanResources.Employee;
GO
FROM Pubs.dbo.titles WHERE type <> 'business'
GO
FROM AdventureWorks.HumanResources.Employee;
GO
FROM Pubs.dbo.titles WHERE type <> 'business'
GO
FROM AdventureWorks.HumanResources.Employee;
GO
FROM Pubs.dbo.titles WHERE type <> 'business'
GO
FROM AdventureWorks.HumanResources.Employee;
GO
FROM Pubs.dbo.titles WHERE type <> 'business'
GO
FROM AdventureWorks.HumanResources.Employee;
GO
FROM Pubs.dbo.titles WHERE type <> 'business'
GO
FROM AdventureWorks.HumanResources.Employee;
GO
FROM Pubs.dbo.titles WHERE type <> 'business'
GO
FROM AdventureWorks.HumanResources.Employee;
GO
Satyapriya NayakPosted Jun 12, 2012, 12:39 PM
Aggregate functions perform a calculation on a set of values and return a single value. With the exception of COUNT, aggregate functions ignore null values. Aggregate functions are often used with the GROUP BY clause of the SELECT statement.
Please refer the below links
http://msdn.microsoft.com/en-us/library/aa258901%28v=sql.80%29.aspx
http://databases.about.com/od/sql/l/aaaggregate1.htm
Thanks