摘要:
语句:比较增加SQL记录比例的结果select tag, percent_rank() over(order by tag asc), cume_dist() over(order by tag asc) from examination_info; 图一 图二 图三 图四 percent_rank 阅读全文
摘要:
用cast(num1 as signed)-cast(num2 as signed) 解决报错BIGINT UNSIGNED value is out of range in... SQL中:两数相减来做查询条件,由于两个字段都是unsigned的,并两个的大小是不一样。所以直接相减查询的时候,会出 阅读全文