Home Forums SQL Server 2005 SQL Server Newbies Order by desc for specific date RE: Order by desc for specific date

  • May 27, 2014 at 1:10 pm

    #1716830

    Hi ,

    MarketShare<table>

    StartDate || Rate

    -------------------

    22/06/2014 234

    28/06/2014 789

    29/06/2014 987

    02/07/2014 890

    i need latest start date record on july 1

    Result :

    StartDate || Rate

    ---------------------

    29/06/2014 987

    thanks in advance