C# .NET - DATE QUERY

Asked By sreya gopal on 09-Aug-12 03:41 AM
HOW TO WRITE QUERY FOR  GETTING THE MAXIMUM DATE FROM A TABLE LESS THAN A PARTICULAR DATE(SAY TODAYS DATE)
Peter Bromberg replied to sreya gopal on 09-Aug-12 07:56 AM
SELECT MAX(datecolumn) Where datecolumn <getDate()