2. Example. WHERE.sql

SELECT *
FROM [ORDER] ord
WHERE ord.OrderDate = '20140101' OR ord.OrderDate = '20140130';
GO

/** Output **/
Id          OrderDate               OrderNumber CustomerId  TotalAmount
----------- ----------------------- ----------- ----------- ---------------------------------------
561         2014-01-01 00:00:00.000 542938      55          1660.00
562         2014-01-01 00:00:00.000 542939      88          140.00
563         2014-01-01 00:00:00.000 542940      42          187.00
614         2014-01-30 00:00:00.000 542991      89          3523.40
615         2014-01-30 00:00:00.000 542992      44          581.00