Wednesday, June 27, 2012

select both SUM and COUNT (it's not that hard)

SELECT OurWord,
SUM(OurNumber) AS OurSum,
COUNT(OurNumber) As OurCount
FROM OurTable
Group By OurWord

No comments:

Post a Comment