max

FINDING NTH ROW GIVING ME DUPLICATES

I can query these separately but am trying to combine results into one query.
First Query – Income value for most max date
`
Select *

FROM

CODES

INNER JOIN OPS
ON CODES.ID = OPS.ID
AND OPS = ‘A’
AND OPS.DATE = (SELECT MAX(DATE) FROM…

Get biggest node from an array

I have an array of SCNNodes and I need to identify which one of them has the highest width.
I know how to calculate the width, but not how to compare among all nodes within the array and return the one with the highest value.
Here’s a samp…

Joining Only on Max Date

I’m having so much trouble with this and I am unsure why. I need a join to a rate code table, but only grabbing the rate code from this table for each member with the max eff date (there are multiple rate codes in the table for each membe…

SQL MAX CON COUNT [closed]

I have a Table named "preventivi" , in this table i have column "ImportoTOT" and "CodCliente". In this table the record is multiple for client , es:
Cod : 1 ImportoTot 100
Cod : 2 ImportoTot 50
Cod : 1 ImportT…