How to select 5 results only ?

martones · #1 (**permalink**) 07-26-04, 05:56

Hi, thakns for reading my post

What is the sql, command to select only 5 results from my table ?

I mean, when I have a table with 100 replies to one topic, and I want to select only 5 of them.

Thanks a lot

r123456 · #2 (**permalink**) 07-26-04, 06:44

Oracle:

Select columns
from table
where rownum <= 5

SQL Server 2000:

Select top 5 columns
from table

martones · #3 (**permalink**) 07-26-04, 08:01

Thanks a lot, gonna try it at once.

laals · #4 (**permalink**) 07-26-04, 08:07

or u have to use the LIMIT statement
optional LIMIT OFF

martones · #5 (**permalink**) 07-26-04, 08:07

Hmm, this doesnt works on my sql server

I tried : "select * from Table where rownum=<5";
and also : "select top 5 colums from table";

martones · #6 (**permalink**) 07-26-04, 08:10

Quote:

Originally Posted by laals

or u have to use the LIMIT statement
optional LIMIT OFF

How to use Limit statement please ?
Thanks

r123456 · #7 (**permalink**) 07-26-04, 08:35

This query will work in MS SQL Server 2000:

Code:

Select top 5 *
from table

martones · #8 (**permalink**) 07-26-04, 09:08

Still doesn't work :/

Code:

$sql="Select top 2 * from clen";
$res=mysql_query($sql);
while($line=mysql_fetch_assoc($res)) echo($line[0]);

gives :

Code:

 Supplied argument is not a valid MySQL result resource in /home/... /html/lib.php on line 258

mhall84 · #9 (**permalink**) 07-26-04, 09:57

SELECT * FROM yourtable LIMIT 2

Looks like you are using MySQL, not Microsoft SQL Server. the TOP statement works in Microsoft SQL Server but I don't think it is in MySQL as a valid statement.

martones · #10 (**permalink**) 07-26-04, 10:06

Yes that's it

It works

Thanks a lot

Internet Services

Web Development

Digital Marketing

Consumer Tech