Notice: Undefined index: HTTP_ACCEPT_ENCODING in C:\server\web\www.showyounger.com\s-system.php on line 2
Oracle分组随机 | 小样儿(ShowYounger)
小样儿,顶呱呱!!![http://www.showyounger.com]
- select tmid, tmname
- from (select t.*,
- row_number() over(partition by tmid order by dbms_random.random) rn
- from t_member t)
- where rn <= 2