id_start id_end 1 2 2 3 3 4 I want to collect elements who are "connected" like [1, 2, 3, 4]. (in an array for example) I tried a recursive query like: WITH RECURSIVE q_rec AS ( SELECT id_start, id_end…
I have a query for deployment table. There is no data for hotfix column now. I want to show all change count without hotfix and with hotfix for time intervals. Table data: deployTime changeno hotfix 2022-08 aaa 2022-08 bbb 2022-11…
I have 2 different date fields, 1 when the case was created and the other when the case completed. I am trying to count total cases and total completions in say 2023. Whenever I run my query and set the…
Get the average traffic from last week data per WEEK number and get the traffic data for last week Traffic(D-7) For example if date = 5/13/2023, need to output traffic data (Traffic(D-7)) for date = 5/6/2023 I manage to get…
total nube in PL/PGSQL. I would like to define an array of strings and then used that in my SELECT... WHERE In statement but can't seem to get it to work, help appreciated. DO $$ DECLARE testArray varchar[] := array['john','lisa'];…
I am using ST_Intersects to check if two polygons intersect. Relevant part of my query is: SELECT entity_number FROM coordinates WHERE ST_INTERSECTS($1, location) It works well to determine if one polygon scrosses the other's surface: I expected ST_Intersects to return…
ID name isSearchable 1 foo true 2 bar true 3 zar false I've got some ids and I need to filter records where they have isSearchable = true. This query give as result ID = 1 because is searchable, but…
Need a MySQL query to fetch product if provided range of price falls between the min and max price. I have product A and product B. Product A has a min price equal to 3400 and max price equal to…
in a DB table, table1 I have the following JSON in column1: { "key1": [ { "subkey1":"somevalue1", "subkey2":"somevalue2", }, { "subkey1":"interestedvalue1", "subkey2":"interestedvalueToParseAndGet", } ] } If I do the following, select JSON_VALUE(column1, '$.key1[1].subkey2') from table1 I'm able to get interestedvalueToParseAndGet…
I am getting 0 row when selecting from OPENJSON below. I am expecting to get all 3 values "AA" for different as_of_date for CREDIT_RTG . I tried different select statements. I am running in SQL 2016. Expected result should be…