zjy974917121的博客

http://localhost:2019/blog/getCommentListInfo?postId=1如何获取postId=1这个参数值呢？很简单通过下面代码即可获取，如:window.onload = function() {var postId = getUrlParms("postId");getByIdCommentInfo(postId);}//获取地址栏参数，n...

select SUM(字段名称) from 表名

select id,count(1) 重复次数 from A group by id having count(1)>1;

SELECT DISTINCTa.fullname,a.belong_user_id AS belong_id,a.store_typeFROMc_store tbl aJOIN c_store_tbl b ON a.store_type != b.store_typeWHEREa.belong_user_id = b.belong_user_idORDER BYa.belon...

查数据库三个字段相同的sqlSELECT *FROM test_abc T1 WHERE EXISTS(SELECT 1 FROM test_abc T2 WHERE T2.ID!=T1.ID AND T2.A=T1.A AND T2.B=T1.B AND T2.C=T1.C)