Re: SQL Count up MAX records

["Art Tostaine, Jr." <atostaine@xxxxxxxxx>]

Thank you.  I think that doesn't work because I only want to count a
carton's highest status.

Art

On Thu, Jan 2, 2020 at 2:27 PM Steve M via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> Art,
>
> I would think the following should work:
>
> Select Status, count(*)
> From X
> Where TimeStamp between 1 and 2
> Group by Status
> Order by Status
>
> Try that...
>
> Steve
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Art
> Tostaine, Jr.
> Sent: Thursday, January 2, 2020 13:20
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: SQL Count up MAX records
>
> I have a table that has a carton# (GS1#), and a numeric status.
>
> A carton will be written 1 to many times in the table, something like this:
>
> GS1, Status, TimeStamp
> 15,10
> 15,20
> 15,30
> 11,10
> 12,10
> 12,20
> 12,60
> 16,20
> 15,40
>
> I want a report like this.  I also need to select a range on the timestamp.
>
> Status, Qty (hopefully I calculated these right lol)
> 10,3
> 20,3
> 40,1
> 60,1
>
>
> --
> Art Tostaine
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link:
> https://amazon.midrange.com
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com