cysx009的博客

oracle判断一个数组中哪些数值不存在于表中

group by就是分组聚合，sum是聚合函数之一

sql的一些函数使用

mySQL取出每个学生的最好的科目分数

This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery’ 解决办法：在外面嵌套一层update receivesheetconfirm set Status=3 where ReceiveSheetNo in (select ReceiveSheetNo from (select ReceiveSheetNo from receivesheetconfirm limit 0,60) tt)`...

select intime,count(intime) from instockdetailtwo GROUP BY intime HAVING count(intime)>1ORDER BY intime;