Home Forums Testing Center Question of the Day (QOD) Question of the Day for 20 Oct 2005 RE: Question of the Day for 20 Oct 2005

  • October 20, 2005 at 5:52 pm

    #598990

    You can northwind this question like this...

    select

    datepart(qq, orderdate) 'day of week'

    , count(*)

    from orders

    group by

    datepart(qq, orderdate)

    you get...

    4202

    3173

    2181

    1274


    {Francisco}