数据库: 随机查询\多列\其他特别操作

SQLite

随机查询

SELECT * FROM 表名 ORDER BY RANDOM() limit 1

SELECT code,value FROM table1 ORDER BY RANDOM(code) LIMIT 1

Example:
select * from alllower_poi_cases 

where source_cat_id='5800'

order by random()

limit 10


Oracle

随机查询

select * from table where code = '5800'
and rownum <= 100
order by dbms_random.value

SQL 2000

随机查询

Select top 100 * from TableName order by NewId()

select * from (select px=row_number() over(order by 日期,姓名),* from 表名)a where px/1000=1

参考文档:

http://blog.sina.com.cn/s/blog_6f97247e01011bhd.html

(未完待续)