SQL count and avg

Posted by mfalac on 12/9/2009 4:10:23 AM under Data Access

return uniqe row

SELECT DISTINCT [ArticleId], [ArticleTitle] FROM [BlogArticles]

sql data getting avg and count data

SELECT        ArticleId, AVG(CONVERT(decimal(4, 2), RateNumber)) AS AvgRating, SUM(RateNumber) AS ExprSumRateNumber, COUNT(ArticleId) AS CountArticleId
FROM            BlogRating
WHERE        ...

    

All Entries Under Count Tag

SQL count and avg

Tag Cloud

Accordion    Animation Extender    Argument Exception    AvgRating    BLL    Calendar    Cascading DropDown    Commit    convert    Count    DAL    Data Edit    Databinding    datepart    DateTime    decimal    Delete    DropDown List    Dynamic Populate Extender    event handler    ExecuteReader    Get Data    if else    Image    insert    Login Status    Loop    Modal Popup Extender    month    Neptun    Parameters    perinaz.com    Popup Control Extender    PopUpExtender    RadioButtonList    Resize    Resize Image Handler    SQL statement    Tab Container    TableAdapter    text to image    Update    WebService   

Top Rated Articles

SQL count and avg
(Avg:4.00 | Rated:9)
binding the DataTable
(Avg:4.00 | Rated:4)
perinaz.com
(Avg:5.00 | Rated:3)
Image Resize
(Avg:3.00 | Rated:4)
Şebnem FERAH - Sigara
(Avg:3.67 | Rated:3)
getting month value
(Avg:3.33 | Rated:3)
first blog
(Avg:3.33 | Rated:3)
Calendar Control And Events
(Avg:3.00 | Rated:3)
PopUpExtender and Comma
(Avg:3.50 | Rated:2)
Dream Antimatter
(Avg:3.00 | Rated:2)
Loading