lets say i have a table like that id name address Doc 1 {1:mark,2:john} {1:Home,2:Work,3:Club} {NI:299,Pass:A159} 2 {1:Max,2:Mo} {1:Home} {NI:300011} what i want is to write a qurey to select a value from cell based on the key for example…
I need to find unique records from mysql table / dataframe. As per the business logic, if the time difference is less than 5 seconds (mobile number and code should be the same) then that record is considered as a…
I have this query I'm running in MySQL: SELECT count(*) FROM library AS l JOIN plays AS p ON p.user_id = l.user_id AND l.path = p.path WHERE l.user_id = 20977 AND p.time >= '2022-10-17'; When EXPLAIN ANALYZE is run: |…
I am looking for the right query to retrieve orders that are 3 calendar years old. Example: It is October 18, 2023, and therefore I want to collect all orders from January 1, 2021 until October 18, 2023. SELECT *…
I want to query a JSONB array using a regex filter. Following the docs, I should be able to do: WHERE jsonb_path_exists( data, '$.value[*] ? (@ like_regex $foo flag "i")', jsonb_build_object('foo', 'demo') ) But I'm getting an error: ERROR: syntax…
I'm trying to extract the following JSON message using SQL: { "document": { "Invoice": { "_NavRecordId": "Purch. Inv. Header: 06IF+230033", "InvoiceNumber": "06IF+230033", "PurchaseOrderNumber": "P0032259", "InvoiceLine": [ { "_NavRecordId": "Purch. Inv. Line: 06IF+230033,1", "item": "A05284", "Quantity": "2", "PurchaseOrderLineNumber": "1" }, {…
I have the following tables: s2s_actions id app_id brand_id country_id ------ ------ -------- ---------- 22 15 361 5 29 15 361 5 35 15 7 64 40 15 7 64 41 15 37 5 44 15 361 5 clicks id…
In my Postgres 13.10 database, I have a table menus with a JSON column named dishes. This column contains values in the following format: { "desserts": [ {"id": 1, "name": "chocolate cake"}, {"id": 2, "name": "banana split"} ], "appetizers": […
I have a table that has a column called id. The table name is called names. I need to show all the id's that have one or more records on the table, and the corresponding fields on the table. The…
I have this table called s2s_actions: id brand_id event_type ------ -------- ---------- 22 361 0 29 361 1 35 7 1 40 7 0 41 37 1 42 37 0 43 37 1 and I want to get the count…