I have a PostgreSQL table which gives me the following output: country metric_code male female pensioners teenagers us metric_1 10 14 22 30 us metric_2 105 142 222 309 uk metric_1 15 13 9 21 uk metric_2 212 264 440…
I have a MySQL transfers table with the following structure: CREATE TABLE `transfers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `id_account_destination` bigint(20) unsigned NOT NULL, `id_account_origin` bigint(20) unsigned NOT NULL, `amount` decimal(10, 2) signed NOT NULL DEFAULT 0, `created_at` datetime…
I have a table which has only one row like below, Here I want to convert the column names to one column and the row into another column, with the column names converted to some predefined numbers as below (A->1E9,…
Looking to Split Hobby column to N multiple columns in PostgreSQL 9.4, where each column header shows the Hobby. Original table Name Hobby Rene Python, Monkey Bars CJ Trading, Python Herlinda Fashion DJ Consulting, Sales Martha Social Media, Teaching Doug…
I have this query in Postgres: Select "Charges"."saleAmount", "Charges"."buyAmount", "Operations"."id" From "Charges" Left Join "Operations" On "Operations"."id" = "Charges"."operationsId" Order By "Operations"."id" saleAmount buyAmount id 200 NULL id1 300 500 id2 0 100 id3 I need to transform it: Add…
I have table like this: Then I want to change the table to this: I usually doing this in Power BI Query Editor but the file is too big so I try in another platform like Bigquery/Postgresql Thank you
This is my query: SELECT * FROM profile_change_set where id = '1558079b-d954-4a0d-b241-b39fe8f3498c'; id table_name column_key column_value operation_type 1558079b-d954-4a0d-b241-b39fe8f3498c farmers smsEnabled somvalue update What is want is to convert all values into rows. column_key column_value id 1558079b-d954-4a0d-b241-b39fe8f3498c table_name farmers column_key smsEnabled…