6. Example. WHERE (comparison operators).sql

SELECT *
FROM [ORDER] ord
WHERE ord.OrderDate BETWEEN '20130101' AND '20130228';
GO

/** Output **/
Id          OrderDate               OrderNumber CustomerId  TotalAmount
----------- ----------------------- ----------- ----------- ---------------------------------------
153         2013-01-01 00:00:00.000 542530      19          3063.00
154         2013-01-01 00:00:00.000 542531      65          3868.60
155         2013-01-02 00:00:00.000 542532      20          2713.50
156         2013-01-03 00:00:00.000 542533      20          1005.90
157         2013-01-03 00:00:00.000 542534      49          1675.00
158         2013-01-06 00:00:00.000 542535      47          400.00
159         2013-01-07 00:00:00.000 542536      62          2018.20
160         2013-01-07 00:00:00.000 542537      56          1194.00
161         2013-01-08 00:00:00.000 542538      23          1622.40
162         2013-01-09 00:00:00.000 542539      54          319.20
...
 
SELECT *
FROM [ORDER] ord
WHERE ord.OrderDate > '20140427';
GO

/** Output **/
Id          OrderDate               OrderNumber CustomerId  TotalAmount
----------- ----------------------- ----------- ----------- ---------------------------------------
807         2014-04-28 00:00:00.000 543184      12          305.00
808         2014-04-28 00:00:00.000 543185      35          1727.50
809         2014-04-28 00:00:00.000 543186      19          3740.00
810         2014-04-29 00:00:00.000 543187      53          45.00
811         2014-04-29 00:00:00.000 543188      6           858.00
812         2014-04-29 00:00:00.000 543189      67          1838.00
813         2014-04-30 00:00:00.000 543190      27          266.00
814         2014-04-30 00:00:00.000 543191      32          510.00
...