As we find the 2 most populated cities, where not. customers are higher than any other
Assuming your circuit looks like this:
Customers -City -SSN
You can simply use limit:
limit
select City, count(SSN) from Customers group by City order by count(SSN) desc limit 2
Source: https://habr.com/ru/post/1768920/More articles:WPF datagrid binding: add a new element - wpfOOPHP - How to create multiple objects from an array of database rows? - oopHow to format a tree so that it works with Clojure zipper? - clojureWhy do UIViewControllers have xib files and no UIViews? - model-view-controllerIs it okay to wrap JSF components generated by html with native divs using jQuery after page loading? - jqueryPostGIS: multipolygon bounding box - sqlcounter_cache не уменьшается для has_many ассоциаций в ActiveReord - ruby-on-railsКак выйти из интерактивного режима в Python - pythonКак использовать $for jQuery внутри domready, когда прототип использует $outside? - javascriptVB.net findwindow / findwindowex - vb.netAll Articles