Home Forums SQL Server 2008 SQL Server Newbies How to show rows in column RE: How to show rows in column

  • October 5, 2014 at 11:23 pm

    #1750214

    punnaiah.pendyala (10/5/2014)

    Hi

    Use this

    select min(wan),max(wan),subscriber from retail group by subscriber having count(*)>1

    Will not work if the earlier wan is higher than the later wan as noted in the previous posts.

    😎