Get Maximum Month or the last month of the year using mysql

by guruprasad 2013-09-24 14:33:34

To Get the last month or the maximum month of the year from the table,we can use the following query,

select max(month(edate)) as Maxmonth from testdb where year(edate)='2013'


This query will retrieve the maximum month of the specified year.


607
like
0
dislike
0
mail
flag

You must LOGIN to add comments