I have an IP-Location database with columns

FirstIP bigint
LastIP bigint
Country char(2)
Region varchar(128)
City varchar(128)

FirstIP is always +1 more than LastIP of the previous row.  LastIP is
always -1 less than FirstIP of the next row.  Here is some sample
data:

50331648    50331903    US    MASSACHUSETTS    BEVERLY
50331904    50332159    US    NEW YORK    MONROE
50332160    50332671    US    CONNECTICUT    FAIRFIELD
50332672    50332927    US    NEW JERSEY    LEBANON

For my purposes I only need FirstIP, LastIP, and Country.  If I delete
the other columns (Region and City), I would then like to roll up the
remaining rows.  This would greatly reduce the number of rows in the
table and would decrease my lookup times by magnitudes.  The data
above would be rolled up into a single row:

50331648    50332927    US

The big question: How would I do such a roll up?