Friday, March 9, 2012

Need MIN date

Hi
I would like to write query to get minimun data from the list of dates. Ie. i have a coumn in the table that conatins all dates from which i need to get minimum date. Please help me.You would like to

select the minimum date from a table

Not certain how to accomplish this

Please post the text book and the page that this question is from so I can better help you|||mark a cross for these dates in a calendar and the first crossed date is the minimum date.|||use min() function|||to use min() function correctly the datatype should be date, if the date is stored in a char field then use convert to make it of date datatype

No comments:

Post a Comment