====Oracle随机抽取数据
SELECT * FROM (SELECT * FROM STUDENT_INFO ORDER BY DBMS_RANDOM.RANDOM() ) WHERE Rownum <= 10;
====MySql随机抽取数据
SELECT * FROM tablename ORDER BY RAND() LIMIT 10;
====Oracle随机抽取数据
SELECT * FROM (SELECT * FROM STUDENT_INFO ORDER BY DBMS_RANDOM.RANDOM() ) WHERE Rownum <= 10;
====MySql随机抽取数据
SELECT * FROM tablename ORDER BY RAND() LIMIT 10;
上一篇:RBAC基础角色用户菜单权限管理
下一篇:BUG(MyBatis)java.lang.AbstractMethodError: org.mybatis.spring.transaction.SpringManagedTransaction.
Oracle查询:取出每组中的第一条记录按type字段分组,co
举报文章
请选择举报类型
补充说明
0/200
上传截图
格式支持JPEG/PNG/JPG,图片不超过1.9M