1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
CREATE TABLE t1(id INT PRIMARY KEY, id1 INT);
INSERT INTO t1 VALUES(1,1),(2,1),(3,2),(4,2);
SELECT MAX(id) AS m1, MAX(id) AS m2, MAX(id) AS m3, MAX(id) AS m4,
MAX(id) AS m5, MAX(id) AS m6, MAX(id) AS m7, MAX(id) AS m8, MAX(id) AS m9,
MAX(id) AS m10,MAX(id) AS m11, MAX(id) AS m12, MAX(id) AS m13, MAX(id) AS
m14, MAX(id) AS m15, MAX(id) AS m16, MAX(id) AS m17, MAX(id) AS m18, MAX(id)
AS m19, MAX(id) AS m20,MAX(id) AS m21, MAX(id) AS m22, MAX(id) AS m23,
MAX(id) AS m24, MAX(id) AS m25, MAX(id) AS m26, MAX(id) AS m27, MAX(id) AS
m28, MAX(id) AS m29, MAX(id) AS m30,MAX(id) AS m31, MAX(id) AS m32, MAX(id)
AS m33, MAX(id) AS m34, MAX(id) AS m35, MAX(id) AS m36, MAX(id) AS m37,
MAX(id) AS m38, MAX(id) AS m39, MAX(id) AS m40,MAX(id) AS m41, MAX(id) AS
m42, MAX(id) AS m43, MAX(id) AS m44, MAX(id) AS m45, MAX(id) AS m46, MAX(id)
AS m47, MAX(id) AS m48, MAX(id) AS m49, MAX(id) AS m50,MAX(id) AS m51,
MAX(id) AS m52, MAX(id) AS m53, MAX(id) AS m54, MAX(id) AS m55, MAX(id) AS
m56, MAX(id) AS m57, MAX(id) AS m58, MAX(id) AS m59, MAX(id) AS m60,MAX(id)
AS m61, MAX(id) AS m62, MAX(id) AS m63, MAX(id) AS m64, MAX(id) AS m65,
MAX(id) AS m66, MAX(id) AS m67, MAX(id) AS m68, MAX(id) AS m69, MAX(id) AS
m70,MAX(id) AS m71, MAX(id) AS m72, MAX(id) AS m73, MAX(id) AS m74, MAX(id)
AS m75, MAX(id) AS m76, MAX(id) AS m77, MAX(id) AS m78, MAX(id) AS m79,
MAX(id) AS m80,MAX(id) AS m81, MAX(id) AS m82, MAX(id) AS m83, MAX(id) AS
m84, MAX(id) AS m85, MAX(id) AS m86, MAX(id) AS m87, MAX(id) AS m88, MAX(id)
AS m89, MAX(id) AS m90,MAX(id) AS m91, MAX(id) AS m92, MAX(id) AS m93,
MAX(id) AS m94, MAX(id) AS m95, MAX(id) AS m96, MAX(id) AS m97, MAX(id) AS
m98, MAX(id) AS m99, MAX(id) AS m100,MAX(id) AS m101, MAX(id) AS m102,
MAX(id) AS m103, MAX(id) AS m104, MAX(id) AS m105, MAX(id) AS m106, MAX(id)
AS m107, MAX(id) AS m108, MAX(id) AS m109, MAX(id) AS m110,MAX(id) AS m111,
MAX(id) AS m112, MAX(id) AS m113, MAX(id) AS m114, MAX(id) AS m115, MAX(id)
AS m116, MAX(id) AS m117, MAX(id) AS m118, MAX(id) AS m119, MAX(id) AS
m120,MAX(id) AS m121, MAX(id) AS m122, MAX(id) AS m123, MAX(id) AS m124,
MAX(id) AS m125, MAX(id) AS m126, MAX(id) AS m127, MAX(id) AS m128, MAX(id)
AS m129, MAX(id) AS m130,MAX(id) AS m131, MAX(id) AS m132, MAX(id) AS m133,
MAX(id) AS m134, MAX(id) AS m135, MAX(id) AS m136, MAX(id) AS m137, MAX(id)
AS m138, MAX(id) AS m139, MAX(id) AS m140,MAX(id) AS m141, MAX(id) AS m142,
MAX(id) AS m143, MAX(id) AS m144, MAX(id) AS m145, MAX(id) AS m146, MAX(id)
AS m147, MAX(id) AS m148, MAX(id) AS m149, MAX(id) AS m150,MAX(id) AS m151,
MAX(id) AS m152, MAX(id) AS m153, MAX(id) AS m154, MAX(id) AS m155, MAX(id)
AS m156, MAX(id) AS m157, MAX(id) AS m158, MAX(id) AS m159, MAX(id) AS
m160,MAX(id) AS m161, MAX(id) AS m162, MAX(id) AS m163, MAX(id) AS m164,
MAX(id) AS m165, MAX(id) AS m166, MAX(id) AS m167, MAX(id) AS m168, MAX(id)
AS m169, MAX(id) AS m170,MAX(id) AS m171, MAX(id) AS m172, MAX(id) AS m173,
MAX(id) AS m174, MAX(id) AS m175, MAX(id) AS m176, MAX(id) AS m177, MAX(id)
AS m178, MAX(id) AS m179, MAX(id) AS m180,MAX(id) AS m181, MAX(id) AS m182,
MAX(id) AS m183, MAX(id) AS m184, MAX(id) AS m185, MAX(id) AS m186, MAX(id)
AS m187, MAX(id) AS m188, MAX(id) AS m189, MAX(id) AS m190, MAX(id) AS m191,
MAX(id) AS m192, MAX(id) AS m193, MAX(id) AS m194, MAX(id) AS m195, MAX(id)
AS m196, MAX(id) AS m197, MAX(id) AS m198, MAX(id) AS m199, MAX(id) AS
m200,MAX(id) AS m201, MAX(id) AS m202, MAX(id) AS m203, MAX(id) AS m204,
MAX(id) AS m205, MAX(id) AS m206, MAX(id) AS m207, MAX(id) AS m208, MAX(id)
AS m209, MAX(id) AS m210,MAX(id) AS m211, MAX(id) AS m212, MAX(id) AS m213,
MAX(id) AS m214, MAX(id) AS m215, MAX(id) AS m216, MAX(id) AS m217, MAX(id)
AS m218, MAX(id) AS m219, MAX(id) AS m220,MAX(id) AS m221, MAX(id) AS m222,
MAX(id) AS m223, MAX(id) AS m224, MAX(id) AS m225, MAX(id) AS m226, MAX(id)
AS m227, MAX(id) AS m228, MAX(id) AS m229, MAX(id) AS m230,MAX(id) AS m231,
MAX(id) AS m232, MAX(id) AS m233, MAX(id) AS m234, MAX(id) AS m235, MAX(id)
AS m236, MAX(id) AS m237, MAX(id) AS m238, MAX(id) AS m239, MAX(id) AS
m240,MAX(id) AS m241, MAX(id) AS m242, MAX(id) AS m243, MAX(id) AS m244,
MAX(id) AS m245, MAX(id) AS m246, MAX(id) AS m247, MAX(id) AS m248, MAX(id)
AS m249, MAX(id) AS m250,MAX(id) AS m251, MAX(id) AS m252, MAX(id) AS m253,
MAX(id) AS m254, MAX(id) AS m255, MAX(id) AS m256,id1 FROM t1 GROUP BY id1;
DROP TABLE t1;
|
