Query question 1

[takaoki]

Hi,

I have a question. Are these "equivalent" statements?

Note: table "h" is defined futher down in the query, which is not shown here. This is just a snippet of the code.

SELECT TOP 1 x.AsOfDate FROM myTable x WHERE x.AsOfDate < h.AsOfDate ORDER BY x.AsOfDate DESC

SELECT MAX(x.AsOfDate) FROM myTable x WHERE x.AsOfDate < h.AsOfDate

Thank you

 

[mrdenny]

Yes, those should return the same value.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog