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

  • July 7, 2012 at 1:36 am

    #1509951

    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 simple exercise made difficult by having to imagine what the table and data look like. Read the link in my sig "please read this" and provide DDL for the table and DML for some sample data.

    Otherwise you may have to imagine what the simple SQL statement might look like 😉

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]