In this sample table fruits, I want to get previous row, current row and next row where high_low_adjstmnt < 0. Table id name low high high_low_adjstmnt volume 1 Apple 5 3 -2 1000 2 Orange 6 9 3 2000 3…
I have a Postgres table with these columns: id int8 , user_id varchar , is_favorite boolean , join_time timestamptz I want to delete some rows in this table with some conditions: Keep a maximum of 10 rows for each user_id.…
I'm learning how to query records in sql and i got stuck at one problem that i can't figure out myself. So basically i have data base called sql_test and i have to group users based on the intervals that…
If I have a field jsonCol which has list of json objects, for example: [{'name': 'fieldA', 'enum': 'someValA'}, {'name': 'fieldB', 'enum': 'someValB'}, {'name': 'fieldC', 'enum': 'someValC'}] Another row may look like: [{'name': 'fieldA', 'enum': 'someValA'}, {'name': 'fieldC', 'enum': 'someValC'}] How…
Here is my base table and i am trying to have a single record for each "app_id". Ex: "XYZ" has 3 records and would like to convert the same to single record and copy the values to the newly added…
I'm trying to generate the following output: type totals CostA 1500 CostB 200 CostC 300 From a table with this structure: CostA CostB CostC name date -- more columns ... The table has more columns but I want the sum…
I'm trying to pull out from this JSON column - "toTimestamp" & "fromTimestamp" so I can calculate instances when the video is above a certain number of seconds. (Postgresql) *Metadata column "videoMetadata": [ { "cameraId":"74", "toTimestamp":"2023-02-15T13:06:43.050Z", "fromTimestamp":"2023-02-15T13:06:39.050Z" }, { "cameraId":"236",…
I'm running the following SQL code: SELECT DISTINCT p.ID FROM {$wpdb->prefix}posts AS p INNER JOIN {$wpdb->prefix}term_relationships AS tr ON p.ID = tr.object_id INNER JOIN {$wpdb->prefix}term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id INNER JOIN {$wpdb->prefix}term_relationships AS tr2 ON p.ID = tr2.object_id…
I'm trying to extract data from Json stored in a column and save as relational data in tables. The Json represents submissions of a pre-start checklist by a driver. The input data is stored in a table, with SubmitId being…
Given the following table: ... | id | type | ... ... | 1 | 1 | ... ... | 1 | 2 | ... ... | 1 | 3 | ... ... | 1 | 4 | ... ...…