åç§æ°æ®åºéæºè·å10æ¡æ°æ®çæ¹æ³
SQL Server:
SELECT TOP 10 * FROM T_USER ORDER BY NEWID()
ORACLE:
SELECT * FROM (SELECT * FROM T_USER ORDER BY DBMS_RANDOM.RANDOM()) WHERE RONUM <= 10
MySQL:
SELECT * FROM T_USER ORDER BY RAND() LIMIT 10
Access:
SELECT TOP 10 * FROM T_USER ORDER BY rnd([ä¸ä¸ªèªå¨ç¼å·å段])
è¿æ¡è¯å¥å¨ Access ä¸çâæ¥è¯¢âä¸æ¯å¯ä»¥è¿è¡å¹¶å¾å°éæºç»æçï¼ä½å¨ ASP.NETçåå°ç¨åºä»£ç ä¸å´æ æ³å¾å°é¢æçéæºææã
æ£ç¡®çåæ³å¦ä¸ï¼
以ASP.NET为ä¾ï¼
Random random = new Random(System.Guid.NewGuid().GetHashCode());
int r = random.Next();
string sql = "SELECT TOP 10 * FROM T_USER ORDER BY RND(" + (-r) + "*èªå¨ç¼å·å段)"
温馨提示:答案为网友推荐,仅供参考