Select Top 100 in a Group By -- MIDRANGE-L

Subject: Select Top 100 in a Group By
From: Mike Wills <mike@xxxxxxxxxxxx>
Date: Fri, 1 Feb 2019 15:29:01 -0600
Arc-authentication-results: i=1; mx.google.com; dkim=pass header.i=@mikewills.me header.s=google header.b=is4Rl1bF; spf=pass (google.com: domain of mike@xxxxxxxxxxxx designates 209.85.220.41 as permitted sender) smtp.mailfrom=mike@xxxxxxxxxxxx; dmarc=pass (p=NONE sp=NONE dis=NONE) header.from=mikewills.me
Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=gPFkVPhdooO56ORFFNgQMDR1M2Oi33StK2x+TkGFfNs=; b=Xqj3yaiVDmaRpcKe/k6PLRtah1qwVUE2k9zsJjrzZr9+uBv1LkYgAFOqus5/TRHO9b vac3x0AqLq5P06grOzKEUtl4I/3toEBnTsoXaje/0k/ApouFLQyqikPYMLW9G0V+VvIU VjaOFCkk+21kvG85uyVtGZ4zmaivWx6aO1NfdiSp2Hd3QIvlgA1BiXOonBH/feLa545P VvtWLKIc6cznPvqa3xxfI4YMTqcIItqi4G46XIJY8+bnSxMYObasbh+AJfzrkg2bhGta VjDTOqgfFQLu9MD7ymLmeOfOTW57shrPyDXN5wUX3GCaBmgXj4UdRXVc7m7gglJV48yp /vjg==
Arc-seal: i=1; a=rsa-sha256; t=1549056578; cv=none; d=google.com; s=arc-20160816; b=f6xM4dBRMOxnU224ybKRX3jV9AgOf9rfrT0SbEluBmHaz42WbS393ecEPE+CLAKVFI fbIyXfNLPSea35hONN/SCDxJNYDerypYYugai1XdL8kNHXIp1pLhB023AawWje0BzCjE TXwairFgxLDB8uUNgiQDp50aqwQKjnmy9Tm4jlH9HL/EUJ9UfSkB3/hbAq3kWyW2ITX1 +NWq+0Zk8uZbx4gn/Q3Xe1PIio4r6cOaNBawXsQm13oiwCUIIYRrphz6RUFcBEy1HzuC EmuZUr6RXcjLiyIz44334+8QrnPGEkNuU96IVQ8TfMJ61zQWisB1TLcQgA9Y0lbFQPvV VTKw==
List-archive: <https://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@lists.midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.lists.midrange.com>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>

Hey everyone, it's been a while.

I am hoping for a shortcut on this, but I'm guessing there isn't. We have a
request to pull a years worth of top usage data by due date.

So we have utility bills by customer and due date. We want to pull all
customers that have the top usage by each billing cycle. I know how to pull
that for all records, is there a shortcut way to pull the top x by a group
by?

I am thinking like
SELECT CUSTOMER, DUE_DATE, TOP100(USAGE)
FROM BILLHIST
GROUP BY CUSTOMER, DUE_DATE

If there isn't, I guess I'll have to get creative. I'd build a program, but
we only need it a couple times until May when this software will be done
and we'll be on a .NET platform.

--
Mike Wills
http://mikewills.me
Ph: 507-933-0880

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

RE: Select Top 100 in a Group By , Birgitta Hauser
RE: Select Top 100 in a Group By , Rob Berendt

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.