sql语句如何限制返回查询结果的条数啊？

gaoyuhangccie 2010-07-20 05:46:10

如题，我是新手希望大家帮下忙啊；
比如说我要查询一个表里的Title，那个列里有几十条数据，我现在只是想让它返回5条，这个语句怎么写啊？

...全文

7721 12 打赏收藏转发到动态举报

写回复

用AI写文章

12 条回复

切换为时间正序

请发表友善的回复…

发表回复

心中的彩虹 2010-07-20

打赏
举报

[Quote=引用 3 楼 gaoyuhangccie 的回复:]
这样吧，我写的句子是这个样子的，现在这个title返回之后就是几百个，我现在就想要5个，能在上面直接改下么？

select title from net_article where articleid in (select articleid from net_article_articleclass where classid='107' and isdeleted !=1)
[/Quote]



select title from net_article where articleid in (select articleid from net_article_articleclass where classid='107' and isdeleted !=1) limit 5

lacus87 2010-07-20

打赏
举报

mysql用limit 0 5，返回前5条

zhizhuo89 2010-07-20

打赏
举报

Select * From (

  Select Rownum num,Title

          From Net_Article

         Where Articleid In (Select Articleid

                               From Net_Article_Articleclass

                              Where Classid = '107'

                                And Isdeleted != 1)

                                And Rownum <=5 ) b

                                 Where b.Num > 0

这是oracle分页。

select title from net_article where articleid in (select articleid from net_article_articleclass where classid='107' and isdeleted !=1) limit 0,5

这是mysql分页。

xieyu_zy 2010-07-20

打赏
举报

你用MYSQL跑这来问，晕，试一试这个吧
select * from net_article where articleid in (select articleid from net_article_articleclass where classid='107' and isdeleted !=1) limit 0,4

minitoy 2010-07-20

打赏
举报

真想踹楼主两脚

yooyoozoo 2010-07-20

打赏
举报

mysql 的你来Oracle提问？

qiao6174 2010-07-20

打赏
举报

SELECT TOP 5 TITLE

  FROM NET_ARTICLE

 WHERE ARTICLEID IN (SELECT ARTICLEID

                       FROM NET_ARTICLE_ARTICLECLASS

                      WHERE CLASSID = '107' AND ISDELETED != 1)

gaoyuhangccie 2010-07-20

打赏
举报

[Quote=引用 4 楼 allanmorgan 的回复:]
引用 3 楼 gaoyuhangccie 的回复:
这样吧，我写的句子是这个样子的，现在这个title返回之后就是几百个，我现在就想要5个，能在上面直接改下么？

select title from net_article where articleid in (select articleid from net_article_articleclass where classid='107……
[/Quote]
[SQL] select * from net_article where articleid in (select articleid from net_article_articleclass where classid='107' and isdeleted !=1) AND rownum <= 1

[Err] 1054 - Unknown column 'rownum' in 'where clause'
我用的mysql的库，是咋回事啊？

allanmorgan 2010-07-20

打赏
举报

SELECT TITLE

  FROM NET_ARTICLE

 WHERE ARTICLEID IN (SELECT ARTICLEID

                       FROM NET_ARTICLE_ARTICLECLASS

                      WHERE CLASSID = '107' AND ISDELETED != 1)

   AND ROWNUM <= 5

gaoyuhangccie 2010-07-20

打赏
举报

这样吧，我写的句子是这个样子的，现在这个title返回之后就是几百个，我现在就想要5个，能在上面直接改下么？

select title from net_article where articleid in (select articleid from net_article_articleclass where classid='107' and isdeleted !=1)