-
使用SQL技巧的作用查看全部
-
SQL語句類型查看全部
-
查詢每個(gè)人打怪最多的日期： select a.user_name,b.timestr,b.kills from user1 a join user_kills b on a.id=b.user_id where b.kills=(select max(c.kills) from user_kills c where c.user_id=b.user_id);查看全部
-
低效的子查詢 select a.user_name,a.over,(select over from user2 b where a.user_name=b.user_name) as over2 from user1 a; 使用join優(yōu)化后的子查詢： select a.user_name,a.over,b.over as over2 from user1 a left join user2 b on a.user_name=b.user_name;查看全部
-
join類型查看全部
-
常見SQL語句類型查看全部
-
分類聚合查詢優(yōu)化SQL:select d.user_name,c.timestr,kills from (select user_id,timestr,kills,(select count(*) from user_kills b where a.user_id=b.user_id and a.kills<=b.kills ) as cnt from user_kills a group by user_id,timestr,kills) c JOIN user1 d on c.user_id=d.id where c.cnt<=2查看全部
-
優(yōu)化sql:select a.user_name,b.timestr,b.kills from user1 a join user_kills b on a.id=b.user_id join user_kills c on b.user_id=c.user_id group by a.user_name,b.timestr,b.kills HAVING b.kills=MAX(c.kills);查看全部
-
ddl 數(shù)據(jù)定義語言 dml 數(shù)據(jù)操作語言【select insert delete update】查看全部
-
更新使用過濾條件中包括自身的表。查看全部
-
解決mysql不支持full join問題。查看全部
-
全連接查看全部
-
左外連接查看全部
-
要得到各人打怪最多的記錄。 方法一： select a.user_name,b.timestr,b.kills from user1 a JOIN user_kill b ON a.i d=b.user_id WHERE b.kills=(select max(kills) from user_kill c where c.user_id=a. id); 子查詢效率低。 方法二： select a.user_name,b.timestr,max(b.kills) from user1 a JOIN user_kill b O N a.id=b.user_id group by a.user_name; 方法三： select a.user_name,b.timestr,b.kills from user1 a JOIN user_kill b ON a.i d=b.user_id JOIN user_kill c ON c.user_id=b.user_id GROUP BY a.user_name,b.timestr,b. kills HAVING b.kills=MAX(c.kills);查看全部
-
join操作類型-Inner join查看全部
舉報(bào)
0/150
提交
取消