Post reply

Write query from (particular period)

  • November 21, 2011 at 2:03 am

    #250786

    I want to query data from (01.09.2011 - 31.10.2011), please do not use PERIOD column to retrieve report),

    Could someone help me?

    Thanks jery

  • November 21, 2011 at 2:04 am

    #1410533

    I'd ask your teacher or classmates to help you first on this one.

    What have you tried and where are you getting stuck?

  • November 21, 2011 at 2:11 am

    #1410540

    SELECT SomeColumn

    FROM SomeTable

    WHERE SomeDateColumn BETWEEN '20110901' AND '20111031'

    -- Gianluca Sartori

  • November 21, 2011 at 7:27 am

    #1410712

    Try this out

    SELECT SomeColumn

    FROM SomeTable

    WHERE SomeDateColumn >= '20110901' AND SomeDateColumn <= '20111031'

    Thanks & Regards
    Syed Sami Ur Rehman
    SQL-Server (Developer)
    Hyderabad
    Email-sami.sqldba@gmail.com

  • November 21, 2011 at 7:30 am

    #1410717

    sami.sqldba (11/21/2011)

    Try this out

    SELECT SomeColumn

    FROM SomeTable

    WHERE SomeDateColumn >= '20110901' AND SomeDateColumn <= '20111031'

    Take your spam somewhere else. Or try to help for real!

  • November 21, 2011 at 7:33 am

    #1410720

    Thanks for every one

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply