title: SQL Server query to get previous month name in string from another month in string
body: <p>I need to get previous month name from given month name.</p>
  
  <p>For example I need to get previous month as May for the given month June.
  There is no date.</p>
  
  <p>I tried <code>select CAST(Monthname-1 AS Varchar(max)) from table</code></p>