Home Forums SQL Server 2005 SQL Server Express tsql code RE: tsql code

  • July 7, 2012 at 1:15 pm

    #1510012

    debris_flow (7/6/2012)

    Imagine a table which contains records for all weekly number of bugs

    discovered by each QA analysts in the team for one year. Please describe a

    simple SQL statement for identifying a winner (an employee who found the

    biggest number of bugs during that year) by writing one statement?

    This is a terrible homework problem. 😛 It doesn't tell you what to do if there's a tie. 😉

    Some hints to solve this (and there are many different ways). Lookup the following in Books Online.

    GROUP BY

    SUM()

    MAX()

    ORDER BY

    COMMON TABLE EXPRESSIONS (CTEs)

    RANK()/DENSERANK()

    ROW_NUMBER()

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)