DROP TABLE IF EXISTS `t2`;
CREATE TABLE `t2` (
  `c1` double NOT NULL default '0',
  `c2` double NOT NULL default '0',
  PRIMARY KEY  (`c1`,`c2`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



INSERT INTO `t2` VALUES (703910.0625,8256.3037109375);
INSERT INTO `t2` VALUES (703910.125,430.7548828125);
INSERT INTO `t2` VALUES (703910.125,993.003967285156);
INSERT INTO `t2` VALUES (703910.125,3434.39428710938);
INSERT INTO `t2` VALUES (703910.125,4158.2607421875);
INSERT INTO `t2` VALUES (703910.125,4452.482421875);
INSERT INTO `t2` VALUES (703910.1875,1032.5771484375);
INSERT INTO `t2` VALUES (703910.1875,7543.10595703125);
INSERT INTO `t2` VALUES (703910.25,5309.76025390625);
INSERT INTO `t2` VALUES (703910.25,8044.27294921875);
INSERT INTO `t2` VALUES (703910.25,9267.8876953125);
INSERT INTO `t2` VALUES (703910.25,9667.2744140625);
INSERT INTO `t2` VALUES (703910.3125,4505.2314453125);
INSERT INTO `t2` VALUES (703910.375,919.0791015625);
INSERT INTO `t2` VALUES (703910.375,4444.99658203125);
INSERT INTO `t2` VALUES (703910.4375,3770.41137695313);
INSERT INTO `t2` VALUES (703910.4375,5331.18408203125);
INSERT INTO `t2` VALUES (703910.4375,6775.43505859375);
INSERT INTO `t2` VALUES (703910.4375,7585.48486328125);
INSERT INTO `t2` VALUES (703910.4375,7781.08251953125);
INSERT INTO `t2` VALUES (703910.5,4223.83935546875);
INSERT INTO `t2` VALUES (703910.5,5794.93994140625);
INSERT INTO `t2` VALUES (703910.5625,8120.35107421875);
INSERT INTO `t2` VALUES (703910.5625,8211.0595703125);
INSERT INTO `t2` VALUES (703910.625,3484.68408203125);
INSERT INTO `t2` VALUES (703910.625,9861.6689453125);
INSERT INTO `t2` VALUES (703910.6875,3201.74658203125);
INSERT INTO `t2` VALUES (703910.6875,4185.30517578125);
INSERT INTO `t2` VALUES (703910.6875,6482.85546875);
INSERT INTO `t2` VALUES (703910.6875,9199.1669921875);
INSERT INTO `t2` VALUES (703910.75,6235.45068359375);
INSERT INTO `t2` VALUES (703910.75,6914.88134765625);
INSERT INTO `t2` VALUES (703910.8125,5550.61962890625);
INSERT INTO `t2` VALUES (703910.8125,9073.8681640625);
INSERT INTO `t2` VALUES (703910.8125,9698.8974609375);
INSERT INTO `t2` VALUES (703910.875,2844.79467773438);
INSERT INTO `t2` VALUES (703910.875,8626.6142578125);
INSERT INTO `t2` VALUES (703910.9375,1259.10876464844);
INSERT INTO `t2` VALUES (703910.9375,7122.3115234375);
INSERT INTO `t2` VALUES (703910.9375,9185.1005859375);
INSERT INTO `t2` VALUES (703911,1305.82836914063);
INSERT INTO `t2` VALUES (703911,3967.25170898438);
INSERT INTO `t2` VALUES (703911,9593.009765625);
INSERT INTO `t2` VALUES (703911.0625,2124.52197265625);
INSERT INTO `t2` VALUES (703911.0625,8843.6162109375);
INSERT INTO `t2` VALUES (703911.125,1500.87719726563);
INSERT INTO `t2` VALUES (703911.125,2031.10632324219);
INSERT INTO `t2` VALUES (703911.125,5949.76513671875);
INSERT INTO `t2` VALUES (703911.1875,371.763793945313);
INSERT INTO `t2` VALUES (703911.1875,1951.5908203125);
INSERT INTO `t2` VALUES (703911.1875,3640.07080078125);
INSERT INTO `t2` VALUES (703911.1875,9089.6494140625);
INSERT INTO `t2` VALUES (703911.25,5526.8388671875);
INSERT INTO `t2` VALUES (703911.25,6457.75390625);
INSERT INTO `t2` VALUES (703911.3125,4891.1005859375);
INSERT INTO `t2` VALUES (703911.3125,6296.28662109375);
INSERT INTO `t2` VALUES (703911.375,3660.89208984375);
INSERT INTO `t2` VALUES (703911.4375,554.864685058594);
INSERT INTO `t2` VALUES (703911.4375,1403.95788574219);
INSERT INTO `t2` VALUES (703911.5,270.177215576172);
INSERT INTO `t2` VALUES (703911.5,5058.5126953125);
INSERT INTO `t2` VALUES (703911.5,8737.7431640625);
INSERT INTO `t2` VALUES (703911.5,9126.921875);
INSERT INTO `t2` VALUES (703911.625,1389.42834472656);
INSERT INTO `t2` VALUES (703911.625,8311.564453125);
INSERT INTO `t2` VALUES (703911.75,1426.47192382813);
INSERT INTO `t2` VALUES (703911.75,9298.138671875);
INSERT INTO `t2` VALUES (703911.8125,1070.9912109375);
INSERT INTO `t2` VALUES (703911.8125,1240.54553222656);
INSERT INTO `t2` VALUES (703911.8125,2403.447265625);
INSERT INTO `t2` VALUES (703911.875,2833.20654296875);
INSERT INTO `t2` VALUES (703911.9375,3125.177734375);
INSERT INTO `t2` VALUES (703911.9375,5168.806640625);
INSERT INTO `t2` VALUES (703911.9375,8385.255859375);
INSERT INTO `t2` VALUES (703911.9375,9666.2509765625);
INSERT INTO `t2` VALUES (703912.0625,4339.9677734375);
INSERT INTO `t2` VALUES (703912.0625,9390.82421875);
INSERT INTO `t2` VALUES (703912.0625,9679.5615234375);
INSERT INTO `t2` VALUES (703912.125,1353.79638671875);
INSERT INTO `t2` VALUES (703912.125,1653.78039550781);
INSERT INTO `t2` VALUES (703912.125,2623.42163085938);
INSERT INTO `t2` VALUES (703912.125,5014.5205078125);
INSERT INTO `t2` VALUES (703912.125,6019.74267578125);
INSERT INTO `t2` VALUES (703912.1875,2763.31811523438);
INSERT INTO `t2` VALUES (703912.25,960.013549804688);
INSERT INTO `t2` VALUES (703912.25,8332.0546875);
INSERT INTO `t2` VALUES (703912.25,8959.134765625);
INSERT INTO `t2` VALUES (703912.3125,1535.24560546875);
INSERT INTO `t2` VALUES (703912.3125,4581.2236328125);
INSERT INTO `t2` VALUES (703912.3125,5422.1103515625);
INSERT INTO `t2` VALUES (703912.3125,7427.3115234375);
INSERT INTO `t2` VALUES (703912.3125,7539.65087890625);
INSERT INTO `t2` VALUES (703912.3125,7691.20068359375);
INSERT INTO `t2` VALUES (703912.3125,8688.2666015625);
INSERT INTO `t2` VALUES (703912.375,3212.92260742188);
INSERT INTO `t2` VALUES (703912.4375,5260.970703125);
INSERT INTO `t2` VALUES (703912.4375,5613.1806640625);
INSERT INTO `t2` VALUES (703912.4375,9000.28125);
INSERT INTO `t2` VALUES (703912.5,2592.58178710938);
INSERT INTO `t2` VALUES (703912.5,6553.767578125);
INSERT INTO `t2` VALUES (703912.5,7602.35546875);
INSERT INTO `t2` VALUES (703912.5,8885.1484375);
INSERT INTO `t2` VALUES (703912.5,9840.673828125);
INSERT INTO `t2` VALUES (703912.5625,281.815734863281);
INSERT INTO `t2` VALUES (703912.625,1485.05322265625);
INSERT INTO `t2` VALUES (703912.625,6566.28076171875);
INSERT INTO `t2` VALUES (703912.625,7166.8115234375);
INSERT INTO `t2` VALUES (703912.625,7333.14697265625);
INSERT INTO `t2` VALUES (703912.625,9704.912109375);
INSERT INTO `t2` VALUES (703912.75,1487.49975585938);
INSERT INTO `t2` VALUES (703912.8125,2448.4765625);
INSERT INTO `t2` VALUES (703912.8125,7111.3896484375);
INSERT INTO `t2` VALUES (703912.8125,8684.0283203125);
INSERT INTO `t2` VALUES (703912.875,307.213409423828);
INSERT INTO `t2` VALUES (703912.875,4496.53173828125);
INSERT INTO `t2` VALUES (703912.9375,2041.31616210938);
INSERT INTO `t2` VALUES (703912.9375,3133.43676757813);
INSERT INTO `t2` VALUES (703912.9375,4818.7978515625);
INSERT INTO `t2` VALUES (703912.9375,5454.8125);
INSERT INTO `t2` VALUES (703912.9375,8029.28173828125);
INSERT INTO `t2` VALUES (703913,2827.02758789063);
INSERT INTO `t2` VALUES (703913.0625,52.9975090026855);
INSERT INTO `t2` VALUES (703913.0625,937.63134765625);
INSERT INTO `t2` VALUES (703913.0625,1508.56481933594);
INSERT INTO `t2` VALUES (703913.0625,4250.8271484375);
INSERT INTO `t2` VALUES (703913.0625,5220.83203125);
INSERT INTO `t2` VALUES (703913.0625,7548.43701171875);
INSERT INTO `t2` VALUES (703913.0625,9102.3408203125);
INSERT INTO `t2` VALUES (703913.125,792.698364257813);
INSERT INTO `t2` VALUES (703913.125,2266.00708007813);
INSERT INTO `t2` VALUES (703913.1875,2077.88623046875);
INSERT INTO `t2` VALUES (703913.1875,7922.607421875);
INSERT INTO `t2` VALUES (703913.1875,9685.9296875);
INSERT INTO `t2` VALUES (703913.25,885.52587890625);
INSERT INTO `t2` VALUES (703913.25,7374.3505859375);
INSERT INTO `t2` VALUES (703913.25,8895.3134765625);
INSERT INTO `t2` VALUES (703913.3125,3647.595703125);
INSERT INTO `t2` VALUES (703913.3125,3679.03100585938);
INSERT INTO `t2` VALUES (703913.3125,7904.39794921875);
INSERT INTO `t2` VALUES (703913.3125,9536.427734375);
INSERT INTO `t2` VALUES (703913.375,1424.66748046875);
INSERT INTO `t2` VALUES (703913.375,6815.498046875);
INSERT INTO `t2` VALUES (703913.4375,1791.25891113281);
INSERT INTO `t2` VALUES (703913.4375,5047.78515625);
INSERT INTO `t2` VALUES (703913.4375,9144.69140625);
INSERT INTO `t2` VALUES (703913.5,616.126708984375);
INSERT INTO `t2` VALUES (703913.5,4354.123046875);
INSERT INTO `t2` VALUES (703913.5,7991.09912109375);
INSERT INTO `t2` VALUES (703913.5,8573.837890625);
INSERT INTO `t2` VALUES (703913.5625,1513.11267089844);
INSERT INTO `t2` VALUES (703913.5625,6656.50146484375);
INSERT INTO `t2` VALUES (703913.625,1175.73791503906);
INSERT INTO `t2` VALUES (703913.625,3128.88647460938);
INSERT INTO `t2` VALUES (703913.625,9295.498046875);
INSERT INTO `t2` VALUES (703913.6875,3475.26245117188);
INSERT INTO `t2` VALUES (703913.6875,6364.32666015625);
INSERT INTO `t2` VALUES (703913.6875,7475.6083984375);
INSERT INTO `t2` VALUES (703913.75,2701.47680664063);
INSERT INTO `t2` VALUES (703913.75,3893.31518554688);
INSERT INTO `t2` VALUES (703913.75,4522.46044921875);
INSERT INTO `t2` VALUES (703913.75,6734.96484375);
INSERT INTO `t2` VALUES (703913.8125,286.232177734375);
INSERT INTO `t2` VALUES (703913.8125,933.142517089844);
INSERT INTO `t2` VALUES (703913.8125,2768.01538085938);
INSERT INTO `t2` VALUES (703913.8125,6587.138671875);
INSERT INTO `t2` VALUES (703913.8125,6719.11279296875);
INSERT INTO `t2` VALUES (703913.8125,8073.84130859375);
INSERT INTO `t2` VALUES (703913.875,5345.97216796875);
INSERT INTO `t2` VALUES (703913.875,8875.63671875);
INSERT INTO `t2` VALUES (703913.9375,8868.501953125);
INSERT INTO `t2` VALUES (703913.9375,8895.37109375);
INSERT INTO `t2` VALUES (703914,4465.3798828125);
INSERT INTO `t2` VALUES (703914.0625,6155.7939453125);
INSERT INTO `t2` VALUES (703914.0625,7917.330078125);
INSERT INTO `t2` VALUES (703914.0625,9103.462890625);
INSERT INTO `t2` VALUES (703914.0625,9940.724609375);
INSERT INTO `t2` VALUES (703914.125,3112.98193359375);
INSERT INTO `t2` VALUES (703914.125,7745.33251953125);
INSERT INTO `t2` VALUES (703914.125,9800.1484375);
INSERT INTO `t2` VALUES (703914.25,381.289093017578);
INSERT INTO `t2` VALUES (703914.25,1306.32629394531);
INSERT INTO `t2` VALUES (703914.25,1586.95642089844);
INSERT INTO `t2` VALUES (703914.25,2134.04028320313);
INSERT INTO `t2` VALUES (703914.25,3537.021484375);
INSERT INTO `t2` VALUES (703914.3125,2883.90673828125);
INSERT INTO `t2` VALUES (703914.375,2430.7880859375);
INSERT INTO `t2` VALUES (703914.375,7623.73388671875);
INSERT INTO `t2` VALUES (703914.4375,2505.71020507813);
INSERT INTO `t2` VALUES (703914.4375,9175.0166015625);
INSERT INTO `t2` VALUES (703914.4375,9299.1513671875);
INSERT INTO `t2` VALUES (703914.4375,9856.4130859375);
INSERT INTO `t2` VALUES (703914.5,2247.54858398438);
INSERT INTO `t2` VALUES (703914.5,5273.84033203125);
INSERT INTO `t2` VALUES (703914.5,7447.55078125);
INSERT INTO `t2` VALUES (703914.5,9155.041015625);
INSERT INTO `t2` VALUES (703914.5625,1289.1533203125);
INSERT INTO `t2` VALUES (703914.5625,9570.4482421875);
INSERT INTO `t2` VALUES (703914.625,1742.49670410156);
INSERT INTO `t2` VALUES (703914.625,4440.1875);
INSERT INTO `t2` VALUES (703914.625,4536.7294921875);
INSERT INTO `t2` VALUES (703914.625,7337.998046875);
INSERT INTO `t2` VALUES (703914.625,9860.03125);
INSERT INTO `t2` VALUES (703914.6875,4306.5458984375);
INSERT INTO `t2` VALUES (703914.6875,4463.7197265625);
INSERT INTO `t2` VALUES (703914.75,2799.33056640625);
INSERT INTO `t2` VALUES (703914.75,3389.71606445313);
INSERT INTO `t2` VALUES (703914.875,679.788146972656);
INSERT INTO `t2` VALUES (703914.875,4610.39404296875);
INSERT INTO `t2` VALUES (703914.9375,1735.66955566406);
INSERT INTO `t2` VALUES (703914.9375,6108.9501953125);
INSERT INTO `t2` VALUES (703915.0625,5769.81396484375);
INSERT INTO `t2` VALUES (703915.0625,9351.1044921875);
INSERT INTO `t2` VALUES (703915.0625,9671.630859375);
INSERT INTO `t2` VALUES (703915.125,1319.38842773438);
INSERT INTO `t2` VALUES (703915.125,1438.38293457031);
INSERT INTO `t2` VALUES (703915.1875,2180.98266601563);
INSERT INTO `t2` VALUES (703915.1875,5778.76123046875);
INSERT INTO `t2` VALUES (703915.25,709.558959960938);
INSERT INTO `t2` VALUES (703915.25,4003.73852539063);
INSERT INTO `t2` VALUES (703915.25,4778.80126953125);
INSERT INTO `t2` VALUES (703915.25,5005.6396484375);
INSERT INTO `t2` VALUES (703915.25,9992.951171875);
INSERT INTO `t2` VALUES (703915.375,960.154235839844);
INSERT INTO `t2` VALUES (703915.375,967.815185546875);
INSERT INTO `t2` VALUES (703915.375,2026.59448242188);
INSERT INTO `t2` VALUES (703915.4375,1833.29565429688);
INSERT INTO `t2` VALUES (703915.4375,4378.96630859375);
INSERT INTO `t2` VALUES (703915.4375,7012.47216796875);
INSERT INTO `t2` VALUES (703915.4375,9432.9638671875);
INSERT INTO `t2` VALUES (703915.5,1277.23364257813);
INSERT INTO `t2` VALUES (703915.6875,4880.85791015625);
INSERT INTO `t2` VALUES (703915.6875,8886.478515625);
INSERT INTO `t2` VALUES (703915.6875,9509.5810546875);
INSERT INTO `t2` VALUES (703915.8125,3242.42431640625);
INSERT INTO `t2` VALUES (703915.8125,6971.3642578125);
INSERT INTO `t2` VALUES (703915.875,8666.5576171875);
INSERT INTO `t2` VALUES (703915.9375,2091.81005859375);
INSERT INTO `t2` VALUES (703916,3679.27880859375);
INSERT INTO `t2` VALUES (703916,4243.322265625);

SELECT COUNT(*) FROM `t2`;
SELECT c1, MAX(c2)  FROM `t2`  WHERE  `c2` < 2453775  AND `c1` = 703913  GROUP BY `c1`;
INSERT INTO `t2` VALUES (7,8);
SELECT COUNT(*) FROM `t2`;
SELECT c1, MAX(c2)  FROM `t2`  WHERE  `c2` < 2453775  AND `c1` = 703913  GROUP BY `c1`;