Re: SQL Max question

Again I may not be understanding what you are doing here but you have an
array so wouldn't it be

table
DID Integer
Sequence Integer
Status Integer or what represents that value.

As I indicated, can you give a table that would be completely unnormalized?

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

There is one row in my first table keyed by did. Other tables are joined
into this view but they are 1-1 by did. I joined it to a status file that
has Did and 1-20 statuses/rows.

In my new table I want all of the fields but only one row per did with the
highest status.

My goal is to create a temp table that I can run reports, extract to csv,
etc.

I wonder if I could create one row per did and then do an update with a
select from the status file getting only the max row from it.

On Sat, Sep 5, 2020 at 10:36 PM Alan Campin <alan0307d@xxxxxxxxx> wrote:

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

--

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

--

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