locked
SQL Retrieve Operation and list in order RRS feed

  • Question

  • How I can list in order event within a time frame?

    Tuesday, November 18, 2014 4:02 PM

Answers

  • Hello,

    The Basic query will look like

    SELECT *
    FROM orders
    WHERE orderDate BETWEEN {d N'2014-10-01} AND {d N'2014-10-31}

    to get all order for October 2014; for more details we need mor informations like table design etc.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, November 18, 2014 4:07 PM
    Answerer

All replies