เลือกช่วงข้อมูล

WITH Grouped AS ( -- Identify groups
 
                 SELECT D.bank_id,
                        grp = D.bank_id - ROW_NUMBER() OVER (
                                                             ORDER BY D.bank_id)
                 FROM banks AS D)
SELECT STUFF ( ( -- Concatenate items in the current group
 
                SELECT [text()] = ',' + CONVERT(varchar(11), G2.bank_id)
                FROM Grouped AS G2
                WHERE G2.grp = Grouped.grp
                ORDER BY G2.bank_id
                FOR XML PATH ('') ) -- Remove initial comma
 , 1, 1, '' )
FROM Grouped
GROUP BY Grouped.grp;

WITH Grouped AS
  ( SELECT D.bank_id,
           grp = D.bank_id - ROW_NUMBER() OVER (
                                                ORDER BY D.bank_id)
   FROM banks AS D)
SELECT MIN(Grouped.bank_id) AS start_id,
       MAX(Grouped.bank_id) AS end_id
FROM Grouped
GROUP BY Grouped.grp