如何从“nb”列中获取最大值“?

Here is how I m getting my first result :

SELECT PageName, COUNT(DISTINCT Ip) as nb FROM statistique INNER JOIN visite ON statistique.Id = visite.IdPage GROUP BY statistique.Id;

And this is what I'm getting : PageName nb /edsa-PHP/index.php 1 /edsa-PHP/test2.php 1 /PHP/index.php 3 /PHP/test2.php 1

PageName              nb
/edsa-PHP/index.php   1
/edsa-PHP/test2.php   1
/PHP/index.php        3
/PHP/test2.php        1

This is how I think I can get the max value of the count :

SELECT MAX(nb) FROM (SELECT PageName, COUNT(DISTINCT Ip) as nb FROM statistique INNER JOIN visite ON statistique.Id = visite.IdPage GROUP BY PageName) AS t;