What cities have the most customers?

View All Scripts Login to Run Script

Script Name What cities have the most customers?
Description What cities have the most customers? - Query returns the top 10 cities which have the most customers
Area SQL General / SQL Query
Contributor raeesgillani
Created Sunday February 25, 2018

Statement 1

SELECT
    COUNT("CUST_ID"), 
    "CUST_CITY" 
FROM SH."CUSTOMERS" 
GROUP BY "CUST_CITY" 
ORDER BY COUNT("CUST_ID") DESC 
FETCH FIRST 10 ROWS ONLY


COUNT("CUST_ID") CUST_CITY
932 Los Angeles
695 Greenwich
637 Killarney
612 Montara
585 Noma
582 Hiseville
576 Arbuckle
557 Wolverhampton
549 Mackville
532 Koeln

10 rows selected.

COUNT("CUST_ID")	CUST_CITY
932	Los Angeles
695	Greenwich
637	Killarney
612	Montara
585	Noma
582	Hiseville
576	Arbuckle
557	Wolverhampton
549	Mackville
532	Koeln

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database