First and Last

[ijitnoin]

In a Access summary query, you can use the following:

First(Date) or Last(Transaction)

Is there a way of converting these over to a column in a query/view of the SQL Server.

I tried MIN(Date) and MAX(Transaction), but I'm not sure either of these will be the same as the First or Last above.

 

[SQLDenis]

Min and Max should work for you, just keep in mind that you will need group by in that case

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/