<div>
select &nbsp;max(date) &nbsp;date from yourtable where date &lt;= getdate()
</div>


select  max(date)  date from yourtable where date <= getdate()

<div>
<br />
select A.* from yourtable A<br />
inner join (<br />
select &nbsp;max(date) &nbsp;[date] , sku &nbsp;from yourtable &nbsp;where date &lt;= getdate() group by sku )B<br />
on A.sku = B.sku and A.[date] = b.[date]<br />

</div>



select A.* from yourtable A
inner join (
select  max(date)  [date] , sku  from yourtable  where date <= getdate() group by sku )B
on A.sku = B.sku and A.[date] = b.[date]


<div>
Select SKU,Min(DateDiff(day,YourD<wbr />ate,GetDat<wbr />e())) from YourTable where DateDiff(day,YourDate,GetD<wbr />ate()) &gt;= 0<br />
Group by SKU<br />
<br />
Regards,<br />
<br />
dduser
</div>


Select SKU,Min(DateDiff(day,YourDate,GetDate())) from YourTable where DateDiff(day,YourDate,GetDate()) >= 0
Group by SKU

Regards,

dduser

<div>
select top 1 * from dbo.TESTDATE where DT &lt;&nbsp;getdate()<br />
order by DT desc
</div>


select top 1 * from dbo.TESTDATE where DT < getdate()
order by DT desc

<div>
<div class="content wysiwyg-content">
Hi, I'm searching the best and simplest way to make the following query:<br />
<br />
I've got some SkU with specific dates. you can find multiple row with same sku, but with different date. <br />
I want the closest date from today (getdate), but not greater.<br />
<br />
Sample.<br />
<br />
ID &nbsp; &nbsp; &nbsp;SKU &nbsp; &nbsp; &nbsp;date<br />
1 &nbsp; &nbsp; &nbsp; &nbsp;abc &nbsp; &nbsp; &nbsp; 01/01/2004<br />
2 &nbsp; &nbsp; &nbsp; &nbsp;abc &nbsp; &nbsp; &nbsp; 01/01/2005<br />
3 &nbsp; &nbsp; &nbsp; &nbsp;abc &nbsp; &nbsp; &nbsp; 01/01/2006<br />
4 &nbsp; &nbsp; &nbsp; &nbsp;abc &nbsp; &nbsp; &nbsp; 01/01/2007<br />
<br />
I want the row with ID 3, because the date is closest than date's row ID1 and ID 2.<br />
<br />
ID 4's date is closest than ID 3's date but is greater than getdate so not good.<br />
<br />
Thank you for your help.<br />

</div>
</div>


Hi, I'm searching the best and simplest way to make the following query:

I've got some SkU with specific dates. you can find multiple row with same sku, but with different date. 
I want the closest date from today (getdate), but not greater.

Sample.

ID      SKU      date
1        abc       01/01/2004
2        abc       01/01/2005
3        abc       01/01/2006
4        abc       01/01/2007

I want the row with ID 3, because the date is closest than date's row ID1 and ID 2.

ID 4's date is closest than ID 3's date but is greater than getdate so not good.

Thank you for your help.


QUERY SEARCHING CLOSEST DATE

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.