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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Lance Wynn]

If you are looking for the earliest be sure to order by that field.
"J. Muenchbourg" <jo*****@canada.com> wrote in message
news:%2********************@TK2MSFTNGP10.phx.gbl.. .
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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[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.
"J. Muenchbourg" <jo*****@canada.com> wrote in message
news:%2********************@TK2MSFTNGP10.phx.gbl.. .

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Aaron Bertrand - MVP]

TOP makes no sense without an ORDER BY clause.


"J. Muenchbourg" <jo*****@canada.com> wrote in message
news:#D**************@TK2MSFTNGP10.phx.gbl...

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[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...

"dlbjr" <do******@do.u> wrote in message
news:#D**************@TK2MSFTNGP12.phx.gbl...

FYI

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

-dlbjr

invariable unerring alien