Select TOP sql statement with date datatypes

[J. Muenchbourg]

I would like to grab the earliest date of any of the records that gets
drawn from this SQL statement:

datesql = "SELECT top 1 gamedate FROM tblNFLGameData WHERE season = '" &
seasonZ & "' and gameweek = '" & gameweekZ & "'"

..this works for some of the simple stuff I'm doing now, but I am going
to have more involved calculations as far as dates and such. Does
"Select Top (whatever value and fieldname) FROM (table name)" have any
rules pertaining to Date data types in SQL?

Thanks
JMuench

 

[Lance Wynn]

If you are looking for the earliest be sure to order by that field.


I would like to grab the earliest date of any of the records that gets
drawn from this SQL statement:

datesql = "SELECT top 1 gamedate FROM tblNFLGameData WHERE season = '" &
seasonZ & "' and gameweek = '" & gameweekZ & "'"

..this works for some of the simple stuff I'm doing now, but I am going
to have more involved calculations as far as dates and such. Does
"Select Top (whatever value and fieldname) FROM (table name)" have any
rules pertaining to Date data types in SQL?

Thanks
JMuench

 

[Tom B]

TOP X
takes the first X "rows" based on the rest of the query. So if your query
sorts by dates ascending, it takes the X oldest. If your query sorts by
dates descending, the X newest.

 

[Aaron Bertrand - MVP]

TOP makes no sense without an ORDER BY clause.

 

[dlbjr]

FYI

Be aware the TOP function of SQL will not work against many versions of
Oracle.

-dlbjr

invariable unerring alien

 

[Aaron Bertrand - MVP]

Well, the OP was using TOP initially, so I assume he is using a database
that supports it...