selecting the top record in sql table
I have a a table with date field and recordid field.
The recordid field has records like 10001 10002 11152 etc.. These id's are repeated as per the date field. 
I want to pick up each recordid once with the maximum date for that recordid.

selecting the top record in sql table
===

I have a a table with date field and recordid field.
The recordid field has records like 10001 10002 11152 etc.. These id's are repeated as per the date field. 
I want to pick up each recordid once with the maximum date for that recordid.
