CREATE TABLE #tbTest  (a bigint ,b varchar(100))
  

  INSERT  #tbTest
  

  SELECT 1,'sa' UNION all
  

  SELECT 3,'sa' UNION ALL
  

  SELECT 6,'sa' UNION ALL
  

  SELECT 9,'b' UNION ALL
  

  SELECT 13,'c' UNION ALL
  

  SELECT 16,'c'  UNION ALL
  

  SELECT 19,'sa'
  

  

  SELECT * FROM #tbTest
  

  

  1   sa
  

  3   sa
  

  6   sa
  

  9   b
  

  13  c
  

  16  c
  

  19  sa
 

  1-6  sa
  

  9-9  b
  

  13-16 c
  

  19-19 sa