count and max from a table

Question

count and max from a table

adisql

SSCrazy

Points: 2893
More actions
July 19, 2022 at 6:15 pm

#4065535

Hi ,
I am looking for a query to find count and max values from a table .
Please see attachment.
Any suggestions pls.

Thank you !
Attachments:
You must be logged in to view attached files.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

kaj SSCommitted Points: 1605 More actions · Answer 1

Should be a very basic query. Try

SELECT Object_Id, Schema_Name, Table_Name, SUM(Value1) AS Value1, MAX(Date1) AS Date1
FROM Table
GROUP BY Object_Id, Schema_Name, Table_Name
ORDER BY Object_Id, Schema_Name, Table_Name

adisql SSCrazy Points: 2893 More actions · Answer 2

Thank you

This reply was modified 2 years, 4 months ago by adisql.

adisql SSCrazy Points: 2893 More actions · Answer 3

I would like to update Table2 with Table select statement results .But somehow it is not working.

update Tabl2 set Value1,Date1

SELECT Object_Id, Schema_Name, Table_Name, SUM(cast(Value1 as bigint)) AS Value1, MAX(Date1) AS Date1

FROM Table

GROUP BY Object_Id, Schema_Name, Table_Name

where Table.Object_id = Table2.object_id

This reply was modified 2 years, 4 months ago by adisql.

Ed B Hall of Fame Points: 3666 More actions · Answer 4

Does this do what you need?

UPDATE a
SET    a.Value1 = b.Value1,
       a.Date1 = b.Date1
FROM   Table2 AS a
JOIN (
       SELECT Object_Id,
              SUM(cast(Value1 as bigint)) AS Value1, 
              MAX(Date1) AS Date1
       FROM   Table1
       GROUP  BY Object_Id
      ) AS b ON a.Object_id = b.Object_id

count and max from a table

Attachments: