2015年10月12日

从表中随机返回n条记录

摘要: 创建测试用表:CREATE OR REPLACE VIEW V ASSELECT 'a' AS c FROM dualUNION ALLSELECT 'b' AS c FROM dualUNION ALLSELECT 'c' AS c FROM dualUNION ALLSELECT 'd' AS ... 阅读全文

posted @ 2015-10-12 20:47 奈何作贼 阅读(359) 评论(0) 推荐(0) 编辑

限制返回的行数

摘要: 创建测试用表:CREATE OR REPLACE VIEW V ASSELECT 'a' AS c FROM dualUNION ALLSELECT 'b' AS c FROM dualUNION ALLSELECT 'c' AS c FROM dualUNION ALLSELECT 'd' AS ... 阅读全文

posted @ 2015-10-12 20:14 奈何作贼 阅读(155) 评论(0) 推荐(0) 编辑

将空值转换为实际值

摘要: 创建测试用表:CREATE OR REPLACE VIEW v ASSELECT NULL AS c1, NULL AS c2, '1' AS c3, NULL AS c4, '2' AS c5 FROM dualUNION ALLSELECT NULL AS c1, NULL AS c2, NUL... 阅读全文

posted @ 2015-10-12 19:51 奈何作贼 阅读(689) 评论(0) 推荐(0) 编辑

导航