I have a query similar to: select * from combined where valid_rating is null order by FIND_IN_SET(provider, (select provider from combined where valid_rating is null group by provider order by count(1) desc) ) Basically, I am trying to order by…
I have a t1 table with duplicates. I would like to identify these duplicates by putting a flag on them. I would like labeled all the lines whose idcommande is unique as "keep" For the same idCommand, we set the…
I'm trying to move from ILIKE to Postgres ~* operator. Tables have bpchar columns (cannot changed). Tried in Postgres 12 create temp table test ( tasudok char(25), nimetus char (100) ) on commit drop ; insert into test values ('123','Teie…
I'm new to postgreSQL and I'm trying to delete a row from a table and then also delete the relevant data from another table and then the linking table; Im trying to learn while doing so im pretty sure what…
I have a bigquery table containing the below data(one column and one row) Josn {'A':{'min':0, 'max':10},'B':{'min':1, 'max':15},'C':{'min':10, 'max':18}} I want to convert the json data into a table as shown below Name min_value max_value A 0 10 B 1 15…
I want to find data between 2 month, for example data between months 8 and 9. Edit: The issue is in this line else if ($bulan1 != "semua" && $bulan2 != "semua") { $query->whereBetween(DB::raw('MONTH(kred_kep_aktf_kompetensi.mulai)'), [8, 9]); } And this is…
Table tmch contains thousands of rows here it is: CREATE TABLE IF NOT EXISTS public.tmch ( id bigserial NOT NULL, year integer, week integer, my_number integer, device_id bigint, CONSTRAINT tmch_pkey PRIMARY KEY (id) ) Sample data: 1716446 2024 37 13…
I need to parse JSON using Oracle SQL select. Here is my JSON: {"result":[ { "field_name1":{"display_value":"TEST1","link":"https://test1.com","value":"abcd"}, "field_name2":{"display_value":"","link":"","value":""}, "field_name3":{"display_value":"TEST3","link":"https://test3.com","value":"efgh"}, "field_name4":{"display_value":"TEST4","link":"https://test3.com","value":"ijkl"} } ]} I want to get results as follows: field_name1:abcd field_name3:efgh field_name4:ijkl excluding those that have nulls in the value. How…
I have the following 2 tables: Person ------ PersonId int PK Name varchar ThingCollectionId int ======================= PersonId Name ThingCollectionId 1 Joe 100 2 Mary 101 3 Dave 102 Thing ----- ThingId int PK ThingCollectionId int Name varchar ======================= ThingId ThingCollectionId…
I'm trying to take a SQL query and turn it into JSON for an API call. I have two groupings that need to contain an opening and closing bracket [] because they can contain multiple rows. Those are shown here…