Write a query to find out the data between ranges?

https://www.simplilearn.com/tutorials/sql-tutorial/sql-between

Hi Naresh,

Please use this query to find range data but it will cosider time as well for StartDate and EndDate,

Select from yourTableName where @Date BETWEEN @StartDate AND @EndDate 

If you want to include both date in your result then you can apply >= and <= in your where caluse for your date,

select * from youRTableName where  CAST(@Date AS date) >= CAST(@FromDate AS date) and CAST(@Date AS date) <= CAST(@ToDate AS date)  

You mean date range (inclusive end date)

then 

select * from table where dateCol>=Mindate and dateCol<=Maxdate

if you want to get date from min and less than max date then use between instead 

select * from table where datecol between MinDate and MaxDate