HOW CAN I GET THE LAST RECORD | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

HOW CAN I GET THE LAST RECORD

I HAVE A TABLE WITH A LIST OF CUSTOMERS REGISTERED.HOW CAN I GET THE LAST RECORD ,THAT IS T HE CUSTOMER WHO HAS REGISTERED FIRST AND TIME OF REGISTRATION
There is no such thing as the last record. In your case you might want to have a look at MIN in BOL. Something like MIN( registrationsdate) should do. —
Frank
http://www.insidesql.de
]]>