摘要:
-- select 后面没有加别名 Encountered a duplicated sql alias [id] during auto-discovery of a native-sql query -- 看看数据库是否没有这个column could not extract ResultSet 阅读全文
摘要:
按日期累加 SELECT b.`date` ,(SELECT SUM(price) FROM bkk a WHERE a.`date`<= b.`date` ) FROM bkk b SELECT a.`date`,COUNT(numberId)"点击人数",(SELECT COUNT(number 阅读全文
摘要:
mysql做法: UPDATE table A LEFT JOIN table B ON A.B_ID = B.B_ID SET A.A_NAME = B.B_NAME; SQLServer做法:update A set A_NAME = B.B_NAME from table A left joi 阅读全文