forum

Home / DeveloperSection / Forums / How to select data from date range between two dates using SQL

How to select data from date range between two dates using SQL

Kate Smith780216-Oct-2013

I have a table with Product_sales name and it holds like below

Product_ID         Sold_by                                Qty           From_date           To_date

     1001                   21                                       17             2013-02-05       2013-03-17

     1002                   78                                        4               2013-02-06       2013-04-11

     1003                   18                                       19              2013-01-05       2013-03-30

Now what is the query if I want to select sales data between two dates from a date range ? (Like Select sales data from 2013-01-03 to 2013-01-09)


Updated on 16-Oct-2013

Can you answer this question?


Answer

1 Answers

Liked By