<div>
DECLARE @PROC_YEAR INT<br />
SET @PROC_YEAR = 1993<br />
WHILE &nbsp;@PROC_YEAR &lt;&nbsp;2012<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BEGIN<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECT @PROC_YEAR AS THE_YEAR, MAX(MY_DATE)AS TE_DATE FROM MY_TABLE WHERE YEAR(MY_DATE) = @PROC_YEAR<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SET @PROC_YEAR = @PROC_YEAR + 1<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;END
</div>


DECLARE @PROC_YEAR INT
SET @PROC_YEAR = 1993
WHILE  @PROC_YEAR < 2012
      BEGIN
            SELECT @PROC_YEAR AS THE_YEAR, MAX(MY_DATE)AS TE_DATE FROM MY_TABLE WHERE YEAR(MY_DATE) = @PROC_YEAR
            SET @PROC_YEAR = @PROC_YEAR + 1
      END

<div>
Haha wow, I apologize for wasting your time. I for some reason thought that wouldn't work and didn't bother to try. Thank you!
</div>


Haha wow, I apologize for wasting your time. I for some reason thought that wouldn't work and didn't bother to try. Thank you!

<div>
No problem at all. Glad I could help.
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
I have a bunch of daily data going back to 1993. I need to pull specific data from the last available day for each year (not always YYYY-12-31) and group by year. <br />
<br />
Any tips on how I can achieve this? I know I can use MAX to get the latest day but I don't now how to do that for each individual year in one table.<br />
<br />
Thanks!
</div>
</div>


Hello,
I have a bunch of daily data going back to 1993. I need to pull specific data from the last available day for each year (not always YYYY-12-31) and group by year. 

Any tips on how I can achieve this? I know I can use MAX to get the latest day but I don't now how to do that for each individual year in one table.

Thanks!

Get last available day of year, from daily data group by year

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.