SELECT ONE Row with the MAX() value on a column
sql, sql-server, t-sql
Solution
select top 1 * from newsletters where IsActive = 1 order by PublishDate desc
Problem
I have a pretty simple dataset of monthly newsletters: ``` id | Name | PublishDate | IsActive 1 | Newsletter 1 | 10/15/2012 | 1 2 | Newsletter 2 | 11/06/2012 | 1 3 | Newsletter 3 | 12/15/2012 | 0 4 | Newsletter 4 | 1/19/2012 | 0 ``` and etc. The PublishDate is unique. Result (based on above): ``` id | Name | PublishDate | IsActive 2 | Newsletter 2 | 11/06/2012 | 1 ``` What I want is pretty simple. I just want the 1 newsletter that IsActive and PublishDate = MAX(PublishDate).