在MYSQL中一个有挑战的SQL语句

我想的是：取文章列表点击量最大的100篇文章，然后再从文章取随机取10篇

select * from u_article where article_id in ( select article_id from u_article order by article_id desc limit 56 ) order by rand() limit 5  这样写 limit 56 不通过

但在网上看有人在MSSQL下写
SELECT * from (SELECT Top 20 * from abc ORDER BY id DESC) abc_别名 ORDER BY Rnd(" & -1*(intRandomNumber) & "*id)
通过了。。。

请问谁知道在MYSQL下如何实现我的想法

---

SQL code:
SELECT
TOP 10 *
from
(SELECT TOP 100 * from TB ORDER BY 点击量 DESC)AS T
ORDER BY NEWID()
?

---

SQL code:
select
top 10 *
from
(select top 100 * from tb order by article_id desc)t
order by newid()

---

楼上的是sql server的写法吧。

---

引用

SQL codeSELECTTOP10*from
(SELECTTOP100*from TBORDERBY 点击量DESC)AS TORDERBYNEWID()?

up

路过，学习...

---

向高手学习

---

引用

SQL codeselecttop10*from
(selecttop100*from tborderby article_iddesc)torderbynewid()

人家是mysql

---

引用

SQL codeselecttop10*from