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

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 如何使用simulink建立一个永磁同步直线电机模型?
  • ¥30 天体光谱图的的绘制并得到星表
  • ¥15 PointNet++的onnx模型只能使用一次
  • ¥20 西南科技大学数字信号处理
  • ¥15 有两个非常“自以为是”烦人的问题急期待大家解决!
  • ¥30 STM32 INMP441无法读取数据
  • ¥15 R语言绘制密度图,一个密度曲线内fill不同颜色如何实现
  • ¥100 求汇川机器人IRCB300控制器和示教器同版本升级固件文件升级包
  • ¥15 用visualstudio2022创建vue项目后无法启动
  • ¥15 x趋于0时tanx-sinx极限可以拆开算吗