Re: SQL Max question

[Alan Campin <alan0307d@xxxxxxxxx>]

I am not completely understanding what you are doing here but normalizing
table structure?

Could you respond with what you see the table structure would look like?

On Sat, Sep 5, 2020 at 6:52 PM Art Tostaine, Jr. <atostaine@xxxxxxxxx>
wrote:

> I have a table that has a DID#, many other columns, and a numeric status
> field.  I want the table to have all the columns and one row per did# with
> the highest status value.
>
> I'd like to either do a delete or create another temp table with only these
> records.  Is this possible?
>
> I've looked at group by but that won't let me keep all columns in the
> table.
> I also checked out  partition  by but that's not what I want.
>
> Thank you
>
> --
> 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@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com