- 博客(4)
- 资源 (2)
- 问答 (1)
- 收藏
- 关注
原创 从数据库表中随机获取N条记录的SQL语句
Oracle: select * from (select * from tableName order by dbms_random.value) where rownum MS SQLServer: select top N * from tableName order by newid() My SQL:
2009-08-03 14:24:00 7713
从数据库表中随机获取N条记录的SQL语句
Oracle: select * from (select * from tableName order by dbms_random.value) where rownum < NMS SQLServer: select top N * from tableName order by newid()My SQL: select * f...
2009-08-03 14:24:00 198
有做Android兼职开发的童鞋吗?
2011-08-03
TA创建的收藏夹 TA关注的收藏夹
TA关注的人