| Author: Sankar Venkat 23 Nov 2008 | Member Level: Silver | Rating:  Points: 3 |
Saravanan,
This will solve your problem.
SELECT MAX(Date) FROM contact
group by CONVERT(VARCHAR(7),Date, 120)
For more details about date format refer
http://www.sql-server-helper.com/tips/date-formats.aspx
|
| Author: Sriman N Vangala 23 Nov 2008 | Member Level: Diamond | Rating: Points: 3 |
Assuming that your requirement is to display the put put like this:
Month MaxAmt
11 12000
12 20000
select month(datecolumn) , max(amt) from Tablename
group by month(datecolumn)
|