Query simplification Oracle Northwind

Question

Task :

Find country to which maximum of customers belong.

Query

SELECT country,

       count(*)

FROM customers

GROUP BY country

HAVING count(*) =

  (SELECT max(max_sal)

   FROM

     (SELECT count(*) max_sal

      FROM customers

      GROUP BY country)) ;

Result:

The Result is correct but i think it is difficult way to write query

Question : Is there any simple way to rewrite this query.

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

I might be missing something, but it can be as simple as this:

SELECT *
  FROM (  SELECT country, COUNT (*) max_sal
            FROM customers
        GROUP BY country
        ORDER BY COUNT (*) DESC)
 WHERE ROWNUM <= 1;

Query simplification Oracle Northwind

Sign up