Converting Access Queries to SQL Server

[NickMalloy]

I have some Access Database where they include sql statements such as

last(date)

how would you convert this to SQL Server? Would you use MAX?

 

[JamesLean]

As data is not stored in any logical order, the concepts of FIRST and LAST do not exist. So, yes, you could use MAX or MIN - basically you just want one record and don't mind which.

--James

 

[NickMalloy]

that's what I thought, but I wanted to clarify. Thanks