Home > Article > Backend Development > 求1sql语句的写法
求1sql语句的写法
- WBOYOriginal
- 2016-06-13 11:19:50881browse
求一sql语句的写法
我需要在留言表中查询最新的30条留言，然后这30条还要随机显示。
------解决方案--------------------
补充一下，就可以了
<br />select * from (SELECT * FROM xxx order by xxx desc limit 30) t order by rand() limit 5<br />
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：在vim中调试php, 装配php code_sniffer,php-md. phpqa.vimNext article：某些网站不提供搜索某些参数的界面，却可以直接在链接中输入参数是咋回事