group Questions

Grouping and sum up all values per day, month and year in SQL – Mysql

April 8, 2023
test
2 Answers

I have a table like this: "time","value" "2023-01-28 01:00:03.520","741" "2023-01-28 14:14:30.520","509" "2023-01-28 14:16:07.238","584" "2023-01-28 14:17:49.630","562" "2023-01-28 14:19:28.024","572" "2023-01-28 14:21:10.336","569" "2023-01-28 14:22:52.757","577" "2023-01-28 14:24:29.733","583" "2023-01-28 14:26:12.163","581" "2023-01-28 14:27:50.475","576" "2023-01-28 14:29:32.869","578" "2023-01-28 14:31:15.612","580" "2023-01-28 14:34:35.110","588" "2023-01-28 14:36:16.407","598" "2023-01-28 14:37:58.818","613" "2023-01-28 14:39:35.873","642" "2023-01-28…

VIEW QUESTION

Select the oldest record of a certain group until it changes pattern, in SQL – Mysql

February 13, 2023
Tanmay
3 Answers

I am trying to get the oldest record for every status update/change in the following table. Table (status_updates) : id entity_id status date 7 2 Approved 2022-02-10 6 2 Approved 2022-02-05 5 2 Approved 2022-02-04 4 2 OnHold 2022-02-04 3…

VIEW QUESTION

AWS Aurora RDS Parameter Group – Is it possible to export from one account and import to another? – Amazon Web Sevices

February 8, 2023
bill
2 Answers

I was hoping that there might be an easy way to export a parameter group from one account to another account. This doesn't seem possible via the aws console. I checked the aws cli rds command documentation, and there is…

VIEW QUESTION

Not getting an error when select a column that is not an aggregate function nor in the group by clause – Mysql

January 18, 2023
ylyu1
2 Answers

VIEW QUESTION

MongoDB aggregate to get stats

January 12, 2023
C0l0red
2 Answers

I've done this sometime last year, but now I really can't recall and can't find any helpful resources. I want to get the statistics of my collection based on types. This is my data object { "_id": { "$oid": "63bfc374378c59a5328f229e"…

VIEW QUESTION

How To Count Values Inside Deeply Nested Array Of Objects in Mongodb Aggregation

January 12, 2023
Mbay
4 Answers

I want to sum of values inside array of objects which have another array of objects. In my case; how can I count 'url' values in all documents inside 'urls' array under 'iocs' array; Mongo playground: open Here is document…

VIEW QUESTION

Mongodb – How to group documents with unique ids and add the values of an array that also uses unique id's?

November 8, 2022
Mizrain
2 Answers

I have the next data in my Mongo DB { sucursal: 1 productos: [ { producto: 1, kilos: 50 } ] }, { sucursal: 2 productos: [ { producto: 1, kilos: 30 }, { producto: 2, kilos: 50 } ]…

VIEW QUESTION

Previous
Page 1
Page 2