ÔÚ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