The maximum of a range of values in SQL

[Overv]

I know how to calculate the maximum value of the whole table:

$res = mysql_query( "SELECT max( field ) FROM table" );

But how would I calculate the maximum value of the first 10 items or item 10 - 20?

[Nisd]

Not shure about Mysql but in T-SQL you can do

select TOP 10 MAX(Field) from Table

And for the second, you should be able to do

select TOP 20 MAX(Field) from Table ORDER BY Field DESC Limit 10

Should only work in Mysql

[turby]

SELECT MAX( field ) FROM (SELECT field FROM table ORDER BY id LIMIT 10)

I've ordered by 'id' there, as MySQL's default sort order is undefined, so you might not get the actual first 10

[Overv]

Your example didn't work, I used a subquery to do the job:

$res = mysql_query( "SELECT max( field ) FROM ( SELECT * FROM table LIMIT 0, 5 ) AS subtbl" )

[b]Edit:[/b] Hey, Turbulence. :ninja: