摘要:
-- 某一天所在周的第一天: -- 我们知道国外的星期的第一天是从星期天开始的,所以DAYOFWEEK('2017-3-10')函数的第一天是星期天: SELECT CASE WHEN DAYNAME(DATE('2017-3-10'))='Sunday' THEN DATE_SUB(DATE('2 阅读全文
摘要:
--联表修改 update xyzrb set xyzrb.xy_card=tablsb.card from xyzrb left join tablsb on xyzrb.xybh=tablsb.xybh --取重复数据的各最大一条 select x.comment as comment,x.fidcoachid as fidcoachid from xcb_comment x rig... 阅读全文
摘要:
public class SortTest { public static void main(String[] args) { int arr[]={12,4,45,23,5,7,9,33}; System.out.println("数组冒泡排序 "); for (int i = 0; i < a 阅读全文