Home Forums SQL Server 2014 Development - SQL Server 2014 SQL Help RE: SQL Help

  • September 3, 2014 at 6:22 am

    #1742751

    select * from

    (

    select ROW_NUMBER()over(Partition by coveragecode) rowno,* from Contract

    )t

    where rowno<=5