daily pastebin goal
26%
SHARE
TWEET

Untitled

a guest Sep 14th, 2018 55 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
  1. select city, colour
  2. from t as t
  3. group by city, colour
  4. having count(*) = (select top (1) count(*)
  5.                    from t as t2
  6.                    where t2.city = t.city
  7.                    group by t2.colour
  8.                    order by count(*) desc, t2.colour
  9.                   );
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top