追风筝的伙伴 2018-11-27 12:10 采纳率: 0%
浏览 1086

mysql查询数据使用 limit 999999和 未使用limit 结果不同 limit的使用方法?

需求:
查询用户房间type为2的房间战绩排行榜 根据 主条件killNum做降序, 次条件scoreNum做降序,一个用户只能出现一次取其最高的数据
在同样环境,数据相同的情况下,查询出来的数据不同 纠结了许久
答案数据返回正确 但是我心里摸不着底SQL感觉还需要优化 也喜欢CSDN的大佬们有时间能看一看

有limit 正常:
图片说明
无limit 不正常:
图片说明

表结构如下:
用户表:
CREATE TABLE ss_account (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 125 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

房间id表:
CREATE TABLE ss_room_inc_id (
id int(11) NOT NULL AUTO_INCREMENT ,
type tinyint(1) NOT NULL ,
create_time int(10) NOT NULL DEFAULT 0 ,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2065 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

房间战绩表:
CREATE TABLE ss_game_record (
id int(11) NOT NULL AUTO_INCREMENT ,
account_id int(11) NOT NULL,
room_id int(11) NOT NULL ,
score_num int(11) NOT NULL,
kill_num int(11) NOT NULL,
PRIMARY KEY (id) USING BTREE,
) ENGINE = InnoDB AUTO_INCREMENT = 156 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

表数据:
INSERT INTO ss_account VALUES (120, 'Dean');
INSERT INTO ss_account VALUES (121, '');
INSERT INTO ss_account VALUES (122, '丑娃儿');
INSERT INTO ss_account VALUES (123, '一万年');
INSERT INTO ss_account VALUES (124, '单打独斗');
INSERT INTO ss_game_record VALUES (2, 120, 1905, 120, 2);
INSERT INTO ss_game_record VALUES (3, 121, 1906, 80, 1);
INSERT INTO ss_game_record VALUES (4, 122, 1907, 70, 5);
INSERT INTO ss_game_record VALUES (5, 122, 1908, 80, 5);
INSERT INTO ss_game_record VALUES (6, 120, 1909, 100, 0);
INSERT INTO ss_game_record VALUES (7, 120, 1910, 70, 0);
INSERT INTO ss_game_record VALUES (8, 120, 1911, 45, 1);
INSERT INTO ss_game_record VALUES (9, 120, 1912, 195, 1);
INSERT INTO ss_game_record VALUES (10, 122, 1913, 110, 4);
INSERT INTO ss_game_record VALUES (11, 120, 1914, 75, 1);
INSERT INTO ss_game_record VALUES (12, 120, 1915, 105, 0);
INSERT INTO ss_game_record VALUES (13, 120, 1916, 140, 1);
INSERT INTO ss_game_record VALUES (14, 120, 1917, 180, 1);
INSERT INTO ss_game_record VALUES (15, 120, 1918, 495, 0);
INSERT INTO ss_game_record VALUES (16, 120, 1919, 170, 1);
INSERT INTO ss_game_record VALUES (17, 120, 1920, 205, 0);
INSERT INTO ss_game_record VALUES (18, 120, 1921, 435, 0);
INSERT INTO ss_game_record VALUES (19, 120, 1922, 95, 1);
INSERT INTO ss_game_record VALUES (20, 120, 1923, 105, 1);
INSERT INTO ss_game_record VALUES (21, 122, 1924, 230, 0);
INSERT INTO ss_game_record VALUES (22, 122, 1925, 145, 0);
INSERT INTO ss_game_record VALUES (23, 122, 1926, 55, 0);
INSERT INTO ss_game_record VALUES (24, 122, 1927, 325, 0);
INSERT INTO ss_game_record VALUES (25, 122, 1928, 235, 0);
INSERT INTO ss_game_record VALUES (26, 122, 1930, 45, 0);
INSERT INTO ss_game_record VALUES (27, 123, 1929, 70, 0);
INSERT INTO ss_game_record VALUES (28, 122, 1931, 25, 0);
INSERT INTO ss_game_record VALUES (29, 122, 1932, 25, 0);
INSERT INTO ss_game_record VALUES (30, 122, 1933, 35, 0);
INSERT INTO ss_game_record VALUES (31, 122, 1934, 25, 0);
INSERT INTO ss_game_record VALUES (32, 122, 1935, 25, 0);
INSERT INTO ss_game_record VALUES (33, 122, 1936, 55, 0);
INSERT INTO ss_game_record VALUES (34, 122, 1937, 25, 0);
INSERT INTO ss_game_record VALUES (35, 122, 1938, 115, 0);
INSERT INTO ss_game_record VALUES (36, 122, 1939, 135, 0);
INSERT INTO ss_game_record VALUES (37, 122, 1940, 105, 0);
INSERT INTO ss_game_record VALUES (38, 122, 1941, 95, 0);
INSERT INTO ss_game_record VALUES (39, 120, 1942, 380, 0);
INSERT INTO ss_game_record VALUES (40, 122, 1943, 45, 0);
INSERT INTO ss_game_record VALUES (41, 120, 1945, 2640, 3);
INSERT INTO ss_game_record VALUES (42, 122, 1944, 35, 0);
INSERT INTO ss_game_record VALUES (43, 122, 1946, 25, 0);
INSERT INTO ss_game_record VALUES (44, 122, 1947, 35, 0);
INSERT INTO ss_game_record VALUES (45, 122, 1948, 30, 0);
INSERT INTO ss_game_record VALUES (46, 122, 1950, 45, 0);
INSERT INTO ss_game_record VALUES (47, 122, 1951, 45, 0);
INSERT INTO ss_game_record VALUES (48, 122, 1952, 35, 0);
INSERT INTO ss_game_record VALUES (49, 122, 1954, 35, 0);
INSERT INTO ss_game_record VALUES (50, 122, 1953, 100, 0);
INSERT INTO ss_game_record VALUES (51, 122, 1956, 100, 0);
INSERT INTO ss_game_record VALUES (52, 122, 1957, 25, 0);
INSERT INTO ss_game_record VALUES (53, 122, 1958, 80, 0);
INSERT INTO ss_game_record VALUES (54, 122, 1955, 30, 0);
INSERT INTO ss_game_record VALUES (55, 122, 1959, 85, 0);
INSERT INTO ss_game_record VALUES (56, 122, 1960, 45, 0);
INSERT INTO ss_game_record VALUES (57, 122, 1961, 45, 0);
INSERT INTO ss_game_record VALUES (58, 122, 1962, 30, 0);
INSERT INTO ss_game_record VALUES (59, 122, 1963, 65, 0);
INSERT INTO ss_game_record VALUES (60, 122, 1964, 75, 0);
INSERT INTO ss_game_record VALUES (61, 122, 1967, 25, 0);
INSERT INTO ss_game_record VALUES (62, 122, 1966, 110, 0);
INSERT INTO ss_game_record VALUES (63, 122, 1968, 25, 0);
INSERT INTO ss_game_record VALUES (64, 122, 1969, 55, 0);
INSERT INTO ss_game_record VALUES (65, 122, 1970, 25, 0);
INSERT INTO ss_game_record VALUES (66, 122, 1974, 45, 0);
INSERT INTO ss_game_record VALUES (67, 122, 1973, 80, 0);
INSERT INTO ss_game_record VALUES (68, 122, 1972, 90, 0);
INSERT INTO ss_game_record VALUES (69, 122, 1971, 110, 0);
INSERT INTO ss_game_record VALUES (70, 122, 1975, 25, 0);
INSERT INTO ss_game_record VALUES (71, 122, 1977, 25, 0);
INSERT INTO ss_game_record VALUES (72, 122, 1976, 100, 0);
INSERT INTO ss_game_record VALUES (73, 122, 1978, 35, 0);
INSERT INTO ss_game_record VALUES (74, 122, 1979, 45, 0);
INSERT INTO ss_game_record VALUES (75, 122, 1980, 40, 0);
INSERT INTO ss_game_record VALUES (76, 122, 1983, 25, 0);
INSERT INTO ss_game_record VALUES (77, 122, 1984, 25, 0);
INSERT INTO ss_game_record VALUES (78, 122, 1981, 180, 0);
INSERT INTO ss_game_record VALUES (79, 122, 1985, 25, 0);
INSERT INTO ss_game_record VALUES (80, 122, 1982, 50, 0);
INSERT INTO ss_game_record VALUES (81, 122, 1989, 25, 0);
INSERT INTO ss_game_record VALUES (82, 122, 1986, 85, 0);
INSERT INTO ss_game_record VALUES (83, 122, 1990, 80, 0);
INSERT INTO ss_game_record VALUES (84, 122, 1987, 165, 0);
INSERT INTO ss_game_record VALUES (85, 122, 1988, 45, 0);
INSERT INTO ss_game_record VALUES (86, 122, 1991, 65, 0);
INSERT INTO ss_game_record VALUES (87, 122, 1992, 40, 0);
INSERT INTO ss_game_record VALUES (88, 122, 1993, 80, 0);
INSERT INTO ss_game_record VALUES (89, 122, 1994, 650, 0);
INSERT INTO ss_game_record VALUES (90, 122, 1995, 140, 0);
INSERT INTO ss_game_record VALUES (91, 122, 1997, 190, 0);
INSERT INTO ss_game_record VALUES (92, 120, 2001, 0, 0);
INSERT INTO ss_game_record VALUES (93, 122, 1999, 75, 0);
INSERT INTO ss_game_record VALUES (94, 120, 2002, 585, 0);
INSERT INTO ss_game_record VALUES (95, 120, 2005, 115, 0);
INSERT INTO ss_game_record VALUES (96, 122, 2003, 125, 0);
INSERT INTO ss_game_record VALUES (97, 122, 2004, 55, 0);
INSERT INTO ss_game_record VALUES (98, 122, 2000, 35, 0);
INSERT INTO ss_game_record VALUES (99, 122, 2006, 90, 0);
INSERT INTO ss_game_record VALUES (100, 120, 2008, 880, 2);
INSERT INTO ss_game_record VALUES (101, 120, 2011, 380, 0);
INSERT INTO ss_game_record VALUES (102, 122, 2009, 180, 0);
INSERT INTO ss_game_record VALUES (103, 120, 2012, 730, 1);
INSERT INTO ss_game_record VALUES (104, 120, 2013, 0, 0);
INSERT INTO ss_game_record VALUES (105, 122, 2007, 310, 0);
INSERT INTO ss_game_record VALUES (106, 120, 2014, 635, 0);
INSERT INTO ss_game_record VALUES (107, 122, 2015, 55, 0);
INSERT INTO ss_game_record VALUES (108, 122, 2016, 75, 0);
INSERT INTO ss_game_record VALUES (109, 122, 2017, 240, 0);
INSERT INTO ss_game_record VALUES (110, 122, 2018, 25, 0);
INSERT INTO ss_game_record VALUES (111, 122, 2019, 140, 0);
INSERT INTO ss_game_record VALUES (112, 122, 2020, 35, 0);
INSERT INTO ss_game_record VALUES (113, 122, 2021, 25, 0);
INSERT INTO ss_game_record VALUES (114, 122, 2022, 40, 0);
INSERT INTO ss_game_record VALUES (115, 122, 2023, 25, 0);
INSERT INTO ss_game_record VALUES (116, 122, 2024, 35, 0);
INSERT INTO ss_game_record VALUES (117, 122, 2025, 25, 0);
INSERT INTO ss_game_record VALUES (118, 122, 2026, 60, 0);
INSERT INTO ss_game_record VALUES (119, 122, 2027, 55, 0);
INSERT INTO ss_game_record VALUES (120, 122, 2028, 25, 0);
INSERT INTO ss_game_record VALUES (121, 122, 2029, 25, 0);
INSERT INTO ss_game_record VALUES (122, 122, 2030, 25, 0);
INSERT INTO ss_game_record VALUES (123, 122, 2031, 105, 0);
INSERT INTO ss_game_record VALUES (124, 122, 2032, 50, 0);
INSERT INTO ss_game_record VALUES (125, 122, 2033, 25, 0);
INSERT INTO ss_game_record VALUES (126, 122, 2034, 25, 0);
INSERT INTO ss_game_record VALUES (127, 122, 2035, 25, 0);
INSERT INTO ss_game_record VALUES (128, 122, 2036, 45, 0);
INSERT INTO ss_game_record VALUES (129, 122, 2037, 25, 0);
INSERT INTO ss_game_record VALUES (130, 122, 2038, 425, 0);
INSERT INTO ss_game_record VALUES (131, 122, 2039, 50, 0);
INSERT INTO ss_game_record VALUES (132, 122, 2040, 65, 0);
INSERT INTO ss_game_record VALUES (133, 122, 2041, 195, 0);
INSERT INTO ss_game_record VALUES (134, 122, 2042, 250, 0);
INSERT INTO ss_game_record VALUES (135, 122, 2043, 25, 0);
INSERT INTO ss_game_record VALUES (136, 122, 2044, 100, 0);
INSERT INTO ss_game_record VALUES (137, 122, 2045, 25, 0);
INSERT INTO ss_game_record VALUES (138, 122, 2046, 70, 0);
INSERT INTO ss_game_record VALUES (139, 122, 2047, 30, 0);
INSERT INTO ss_game_record VALUES (140, 122, 2048, 110, 0);
INSERT INTO ss_game_record VALUES (141, 122, 2050, 25, 0);
INSERT INTO ss_game_record VALUES (142, 122, 2049, 330, 0);
INSERT INTO ss_game_record VALUES (143, 122, 2051, 45, 0);
INSERT INTO ss_game_record VALUES (144, 122, 2052, 35, 0);
INSERT INTO ss_game_record VALUES (145, 122, 2053, 25, 0);
INSERT INTO ss_game_record VALUES (146, 122, 2054, 110, 0);
INSERT INTO ss_game_record VALUES (147, 122, 2055, 230, 0);
INSERT INTO ss_game_record VALUES (148, 122, 2056, 105, 0);
INSERT INTO ss_game_record VALUES (149, 122, 2057, 175, 0);
INSERT INTO ss_game_record VALUES (150, 122, 2058, 585, 0);
INSERT INTO ss_game_record VALUES (151, 122, 2059, 60, 0);
INSERT INTO ss_game_record VALUES (152, 122, 2060, 160, 0);
INSERT INTO ss_game_record VALUES (153, 122, 2061, 170, 0);
INSERT INTO ss_game_record VALUES (154, 122, 2062, 255, 0);
INSERT INTO ss_game_record VALUES (155, 122, 2063, 250, 0);

INSERT INTO ss_room_inc_id VALUES (1905, 2, 1543304140);
INSERT INTO ss_room_inc_id VALUES (1906, 2, 1543304154);
INSERT INTO ss_room_inc_id VALUES (1907, 2, 1543304140);
INSERT INTO ss_room_inc_id VALUES (1908, 2, 1143304770);
INSERT INTO ss_room_inc_id VALUES (1909, 1, 1543304770);
INSERT INTO ss_room_inc_id VALUES (1910, 1, 1543304770);
INSERT INTO ss_room_inc_id VALUES (1911, 1, 1543304862);
INSERT INTO ss_room_inc_id VALUES (1912, 2, 1543304862);
INSERT INTO ss_room_inc_id VALUES (1913, 2, 1543304862);
INSERT INTO ss_room_inc_id VALUES (1914, 1, 1543305379);
INSERT INTO ss_room_inc_id VALUES (1915, 1, 1543305379);
INSERT INTO ss_room_inc_id VALUES (1916, 1, 1543305491);
INSERT INTO ss_room_inc_id VALUES (1917, 1, 1543305491);
INSERT INTO ss_room_inc_id VALUES (1918, 1, 1543306739);
INSERT INTO ss_room_inc_id VALUES (1919, 1, 1543306740);
INSERT INTO ss_room_inc_id VALUES (1920, 2, 1543306872);
INSERT INTO ss_room_inc_id VALUES (1921, 2, 1543306930);
INSERT INTO ss_room_inc_id VALUES (1922, 1, 1543306934);
INSERT INTO ss_room_inc_id VALUES (1923, 1, 1543306934);
INSERT INTO ss_room_inc_id VALUES (1924, 1, 1543308579);
INSERT INTO ss_room_inc_id VALUES (1925, 1, 1543308579);
INSERT INTO ss_room_inc_id VALUES (1926, 1, 1543309072);
INSERT INTO ss_room_inc_id VALUES (1927, 1, 1543309072);
INSERT INTO ss_room_inc_id VALUES (1928, 1, 1543309199);
INSERT INTO ss_room_inc_id VALUES (1929, 1, 1543309199);
INSERT INTO ss_room_inc_id VALUES (1930, 1, 1543309277);
INSERT INTO ss_room_inc_id VALUES (1931, 1, 1543309277);
INSERT INTO ss_room_inc_id VALUES (1932, 1, 1543309626);
INSERT INTO ss_room_inc_id VALUES (1933, 1, 1543309626);
INSERT INTO ss_room_inc_id VALUES (1934, 1, 1543309635);
INSERT INTO ss_room_inc_id VALUES (1935, 1, 1543309636);
INSERT INTO ss_room_inc_id VALUES (1936, 1, 1543309685);
INSERT INTO ss_room_inc_id VALUES (1937, 1, 1543309685);
INSERT INTO ss_room_inc_id VALUES (1938, 1, 1543309722);
INSERT INTO ss_room_inc_id VALUES (1939, 1, 1543309722);
INSERT INTO ss_room_inc_id VALUES (1940, 1, 1543309770);
INSERT INTO ss_room_inc_id VALUES (1941, 1, 1543309770);
INSERT INTO ss_room_inc_id VALUES (1942, 2, 1543309797);
INSERT INTO ss_room_inc_id VALUES (1943, 1, 1543309889);
INSERT INTO ss_room_inc_id VALUES (1944, 1, 1243309889);
INSERT INTO ss_room_inc_id VALUES (1945, 2, 1243310030);
INSERT INTO ss_room_inc_id VALUES (1946, 1, 1543310151);
INSERT INTO ss_room_inc_id VALUES (1947, 1, 1543310151);
INSERT INTO ss_room_inc_id VALUES (1948, 1, 1543310160);
INSERT INTO ss_room_inc_id VALUES (1949, 1, 1543310160);
INSERT INTO ss_room_inc_id VALUES (1950, 1, 1543310233);
INSERT INTO ss_room_inc_id VALUES (1951, 1, 1543310233);
INSERT INTO ss_room_inc_id VALUES (1952, 1, 1543310244);
INSERT INTO ss_room_inc_id VALUES (1953, 1, 1543310244);
INSERT INTO ss_room_inc_id VALUES (1954, 1, 1543310255);
INSERT INTO ss_room_inc_id VALUES (1955, 1, 1543310255);
INSERT INTO ss_room_inc_id VALUES (1956, 1, 1543310300);
INSERT INTO ss_room_inc_id VALUES (1957, 1, 1543310300);
INSERT INTO ss_room_inc_id VALUES (1958, 1, 1543310462);
INSERT INTO ss_room_inc_id VALUES (1959, 1, 1543310462);
INSERT INTO ss_room_inc_id VALUES (1960, 1, 1543310487);
INSERT INTO ss_room_inc_id VALUES (1961, 1, 1543310487);
INSERT INTO ss_room_inc_id VALUES (1962, 1, 1543310496);
INSERT INTO ss_room_inc_id VALUES (1963, 1, 1543310496);
INSERT INTO ss_room_inc_id VALUES (1964, 1, 1543310561);
INSERT INTO ss_room_inc_id VALUES (1965, 1, 1543310561);
INSERT INTO ss_room_inc_id VALUES (1966, 1, 1543310902);
INSERT INTO ss_room_inc_id VALUES (1967, 1, 1543310902);
INSERT INTO ss_room_inc_id VALUES (1968, 1, 1543310946);
INSERT INTO ss_room_inc_id VALUES (1969, 1, 1543310946);
INSERT INTO ss_room_inc_id VALUES (1970, 1, 1543310953);
INSERT INTO ss_room_inc_id VALUES (1971, 1, 1543310953);
INSERT INTO ss_room_inc_id VALUES (1972, 1, 1543310961);
INSERT INTO ss_room_inc_id VALUES (1973, 1, 1543310961);
INSERT INTO ss_room_inc_id VALUES (1974, 1, 1543310967);
INSERT INTO ss_room_inc_id VALUES (1975, 1, 1543310991);
INSERT INTO ss_room_inc_id VALUES (1976, 1, 1543310991);
INSERT INTO ss_room_inc_id VALUES (1977, 1, 1543311000);
INSERT INTO ss_room_inc_id VALUES (1978, 1, 1543311000);
INSERT INTO ss_room_inc_id VALUES (1979, 1, 1543311011);
INSERT INTO ss_room_inc_id VALUES (1980, 1, 1543311011);
INSERT INTO ss_room_inc_id VALUES (1981, 1, 1543311012);
INSERT INTO ss_room_inc_id VALUES (1982, 1, 1543311012);
INSERT INTO ss_room_inc_id VALUES (1983, 1, 1543311020);
INSERT INTO ss_room_inc_id VALUES (1984, 1, 1543311020);
INSERT INTO ss_room_inc_id VALUES (1985, 1, 1543311031);
INSERT INTO ss_room_inc_id VALUES (1986, 1, 1543311031);
INSERT INTO ss_room_inc_id VALUES (1987, 1, 1543311034);
INSERT INTO ss_room_inc_id VALUES (1988, 1, 1543311034);
INSERT INTO ss_room_inc_id VALUES (1989, 1, 1543311038);
INSERT INTO ss_room_inc_id VALUES (1990, 1, 1543311038);
INSERT INTO ss_room_inc_id VALUES (1991, 1, 1543311067);
INSERT INTO ss_room_inc_id VALUES (1992, 1, 1543311067);
INSERT INTO ss_room_inc_id VALUES (1993, 1, 1543311091);
INSERT INTO ss_room_inc_id VALUES (1994, 1, 1543311091);
INSERT INTO ss_room_inc_id VALUES (1995, 1, 1543311227);
INSERT INTO ss_room_inc_id VALUES (1996, 1, 1543311227);
INSERT INTO ss_room_inc_id VALUES (1997, 1, 1543311283);
INSERT INTO ss_room_inc_id VALUES (1998, 1, 1543311283);
INSERT INTO ss_room_inc_id VALUES (1999, 1, 1543311339);
INSERT INTO ss_room_inc_id VALUES (2000, 1, 1543311339);
INSERT INTO ss_room_inc_id VALUES (2001, 2, 1543311342);
INSERT INTO ss_room_inc_id VALUES (2002, 2, 1543311400);
INSERT INTO ss_room_inc_id VALUES (2003, 1, 1543311400);
INSERT INTO ss_room_inc_id VALUES (2004, 1, 1543311400);
INSERT INTO ss_room_inc_id VALUES (2005, 2, 1543311416);
INSERT INTO ss_room_inc_id VALUES (2006, 1, 1543311514);
INSERT INTO ss_room_inc_id VALUES (2007, 1, 1543311514);
INSERT INTO ss_room_inc_id VALUES (2008, 2, 1543311526);
INSERT INTO ss_room_inc_id VALUES (2009, 1, 1543311651);
INSERT INTO ss_room_inc_id VALUES (2010, 1, 1543311651);
INSERT INTO ss_room_inc_id VALUES (2011, 2, 1543311661);
INSERT INTO ss_room_inc_id VALUES (2012, 2, 1543311716);
INSERT INTO ss_room_inc_id VALUES (2013, 2, 1543311718);
INSERT INTO ss_room_inc_id VALUES (2014, 2, 1543311787);
INSERT INTO ss_room_inc_id VALUES (2015, 1, 1543312046);
INSERT INTO ss_room_inc_id VALUES (2016, 1, 1543312046);
INSERT INTO ss_room_inc_id VALUES (2017, 1, 1543312119);
INSERT INTO ss_room_inc_id VALUES (2018, 1, 1543312119);
INSERT INTO ss_room_inc_id VALUES (2019, 1, 1543312257);
INSERT INTO ss_room_inc_id VALUES (2020, 1, 1543312257);
INSERT INTO ss_room_inc_id VALUES (2021, 1, 1543312319);
INSERT INTO ss_room_inc_id VALUES (2022, 1, 1543312319);
INSERT INTO ss_room_inc_id VALUES (2023, 1, 1543312498);
INSERT INTO ss_room_inc_id VALUES (2024, 1, 1543312498);
INSERT INTO ss_room_inc_id VALUES (2025, 1, 1543312561);
INSERT INTO ss_room_inc_id VALUES (2026, 1, 1543312561);
INSERT INTO ss_room_inc_id VALUES (2027, 1, 1543312622);
INSERT INTO ss_room_inc_id VALUES (2028, 1, 1543312622);
INSERT INTO ss_room_inc_id VALUES (2029, 1, 1543312761);
INSERT INTO ss_room_inc_id VALUES (2030, 1, 1543312761);
INSERT INTO ss_room_inc_id VALUES (2031, 1, 1543312920);
INSERT INTO ss_room_inc_id VALUES (2032, 1, 1543312920);
INSERT INTO ss_room_inc_id VALUES (2033, 1, 1543313082);
INSERT INTO ss_room_inc_id VALUES (2034, 1, 1543313082);
INSERT INTO ss_room_inc_id VALUES (2035, 1, 1543313189);
INSERT INTO ss_room_inc_id VALUES (2036, 1, 1543313189);
INSERT INTO ss_room_inc_id VALUES (2037, 1, 1543313720);
INSERT INTO ss_room_inc_id VALUES (2038, 1, 1543313720);
INSERT INTO ss_room_inc_id VALUES (2039, 1, 1543313906);
INSERT INTO ss_room_inc_id VALUES (2040, 1, 1543313906);
INSERT INTO ss_room_inc_id VALUES (2041, 1, 1543314357);
INSERT INTO ss_room_inc_id VALUES (2042, 1, 1543314357);
INSERT INTO ss_room_inc_id VALUES (2043, 1, 1543314600);
INSERT INTO ss_room_inc_id VALUES (2044, 1, 1543314600);
INSERT INTO ss_room_inc_id VALUES (2045, 1, 1543314977);
INSERT INTO ss_room_inc_id VALUES (2046, 1, 1543314977);
INSERT INTO ss_room_inc_id VALUES (2047, 1, 1543315498);
INSERT INTO ss_room_inc_id VALUES (2048, 1, 1543315498);
INSERT INTO ss_room_inc_id VALUES (2049, 1, 1543315563);
INSERT INTO ss_room_inc_id VALUES (2050, 1, 1543315563);
INSERT INTO ss_room_inc_id VALUES (2051, 1, 1543315604);
INSERT INTO ss_room_inc_id VALUES (2052, 1, 1543315604);
INSERT INTO ss_room_inc_id VALUES (2053, 1, 1543315678);
INSERT INTO ss_room_inc_id VALUES (2054, 1, 1543315678);
INSERT INTO ss_room_inc_id VALUES (2055, 1, 1543316230);
INSERT INTO ss_room_inc_id VALUES (2056, 1, 1543316230);
INSERT INTO ss_room_inc_id VALUES (2057, 1, 1543316396);
INSERT INTO ss_room_inc_id VALUES (2058, 1, 1543316396);
INSERT INTO ss_room_inc_id VALUES (2059, 1, 1543318165);
INSERT INTO ss_room_inc_id VALUES (2060, 1, 1543318165);
INSERT INTO ss_room_inc_id VALUES (2061, 1, 1543318189);
INSERT INTO ss_room_inc_id VALUES (2062, 1, 1543318189);
INSERT INTO ss_room_inc_id VALUES (2063, 1, 1543318237);
INSERT INTO ss_room_inc_id VALUES (2064, 1, 1543318237);

  • 写回答

1条回答 默认 最新

  • Lei_Da_Gou 2018-11-28 00:56
    关注

    加limit可以让mysql先执行排序,后分组。这个恰恰是解决order by 和group by一起使用时,order by无效的方式。

    评论

报告相同问题?

悬赏问题

  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 ubuntu系统下挂载磁盘上执行./提示权限不够
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)