If this is in the wrong group lemme know and I'll re-post it to the
correct one. I am using PHP and MySQL.

Suppose I have a table named "servicios" with 5 columns and 200 rows.

If I want to get the whole table sorted by column 3 (suppose the field
name is "nf") I use:

SELECT * FROM `servicios` ORDER BY `nf` ASC

This workd perfectly.

If I want to get just the first 10 rows with _no_ sorting I would use:

SELECT * FROM `servicios` LIMIT 10

This also works perfectly.

Now, if I want to get the first 10 rows, sorted by "nf", I use:

SELECT * FROM `servicios` ORDER BY `nf` ASC LIMIT 10

This does NOT work perfectly. The result I get is the first 10 rows of
whole table which has been sorted by "nf". What I want is just the
resulting first 10 rows to be sorted by "nf", not the whole table.

How can I do this?

Thanks,
Philippe

P.S. I am very new to MySQL, please forgive any unforgivable begginer
mistakes.

Philippe Signoret (philippe.signoret (AT) gmail (DOT) com) writes:
Indeed, this is the wrong newsgroup. This news group is for Microsoft
SQL Server. And as your post is about syntax that is peculiar to MySQL,
it's useless that I try to answer.

There is a comp.databases.mysql. Try this instead.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thanks you, my apologies.