Print first value of output?

[vb89]

I have the following query

 SELECT count(*), COUNTRY_DESC 
FROM customer_data.cd_soccer_field_season 
WHERE SEASON_ID = 200849 
group by country_desc
order by count(*)desc

how do i go about printing out only the first row of the output?

 

[Thargy]

Try this

SELECT * 
  FROM
(
 SELECT count(*), COUNTRY_DESC 
   FROM customer_data.cd_soccer_field_season 
  WHERE SEASON_ID = 200849 
  GROUP BY country_desc
  ORDER BY count(*)desc
)
 WHERE ROWNUM < 2;

Regards

T