I want export data from my SQL database. Simply use : SELECT `id`,`tags` FROM `posts` This query give me those results : (1, 'handshake,ssl,windows'), (2, 'office,word,windows'), (3, 'site') I want results in this form: (1, 'handshake'), (1, 'ssl'), (1, 'windows'),…
I have a table CREATE TABLE items( id SERIAL PRIMARY KEY, group_id INT NOT NULL, item_id INT NOT NULL, name TEXT, ..... ..... ); I am creating a function that takes set of row values for a single group_id, fail…
I am new to SQL and still learning functions and triggers. I have 3 tables: PRODUCTS_BOUGHT CUSTOMER DATE PRODUCTS 3FG 2022-12-15 25 4HZ 2022-12-18 30 PRODUCTS_PRICE: DATE TYPE PRICE 2022-12-15 A 125$ 2022-12-18 B 147$ CUSTOMERS_REGISTER: CUSTOMER TYPE 3FG A…
I have the following structure: Training Type Contains multiple sessions Each session can have multiple slots A slot has a start date. (date column) How to compute for each Training Type the total of sessions whose all the slots are…
i need to get the top touristCount in each month like January Zambia has 4 touristCount i need to select only Zambia for January and so on user `useri_id` | `username` | `email` | `nationality` 1 Joseph `` US 2…
I'm using Postgresql,and I have a table named stock,this table has no index or id: open high low close volume datetime 383.97 384.22 383.66 384.08 1298649 2022-12-16 14:25:00 383.59 384.065 383.45 383.98 991327 2022-12-16 14:20:00 383.59 384.065 383.45 383.98 991327…
I have created an azure SQL single database "w3s_singledb" with no elastic pool and SQL server named "singledb2022dec". After logging into "singledb2022dec.database.windows.net" I executed "create database w3s_seconddb" and it was created. Next, I created Azure Elastic Pool "elasticpool2022dec" and SQL…
I have a stored procedure in redshift and calling it by lambda function ...problem is with max time limit that is 15min for lambda function or that it give timeout error but our stored procedure require time more than that…
Following Sergey's example here, https://stackoverflow.com/a/60834163/1513027 I'm trying to create an anonymous DO block rather than a function. If I have the FETCH inside the block, it gives a syntax error, possibly wanting an INTO clause. And it doesn't matter whether…
I have a table named assets: create table assets ( id bigint primary key, name varchar(255) not null, value double precision not null, business_time timestamp with time zone, insert_time timestamp with time zone default now() not null ); I am…