Below is the query: I got this query over internet while searching to sort comma separated values in a single column SELECT id, title, GROUP_CONCAT(aNumber ORDER BY aNumber) FROM ( SELECT id, title, CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(numbers, ',', tens.acnt * 10 + units.acnt…
Considering the case in which we've got two tables, say: SubscriptionPayments and OrderPayments inherit the shared table Payments. Is there a way to find out within the table Payments which table any record belongs to; in other words, is it…
I try to get an amount by joining id and date, but I get an error in the group and the join clause. The expected result is to bring the amount for the max date and lastdate from table 2…
Hi I have some questions regarding table functions in PostgreSQL From https://www.postgresql.org/docs/16/queries-table-expressions.html#QUERIES-TABLEFUNCTIONS CREATE TABLE foo (fooid int, foosubid int, fooname text); CREATE FUNCTION getfoo(int) RETURNS SETOF foo AS $$ SELECT * FROM foo WHERE fooid = $1; $$ LANGUAGE SQL;…
I have a category, percentage table in SQL (the table itself has been obtained by the following query: SELECT p.category, sum(p.sales) * 100 / sum(sum(p.sales)) OVER () AS percentage FROM product p GROUP BY p.category; Category Percentage Books 20.51% Clocks…
I have two tables: DOCUMENT and ITEM. Each DOCUMENT has multiple ITEMS, so ITEM has a foreign key to DOCUMENT, let's name it document_id. I want to write a query, to get the total number of documents, that have specific…
I am using multiple concat with like but I am not getting all the output from the table. I am using below SQL query below in the database. select company_id as ID, concat( c.list_rank, '|||', c.company_name, '|||', c.company_size, '|||', c.industry…
hope you can help write a sql query for table X. I have a table with rows per timestamp, filled with User_ID's and weather they have been in variant A or B of the a/b test. I want to select…
My goal is to search for SKU values that are duplicated if we exclude special characters and get ids of those records. INSERT INTO sneakers (sneaker_id, sku) VALUES (1, '111-111'), (2, '111/111'), (3, '222-222'), (4, '333:333'), (5, '333-333'); In this…
ID StartTime StartLocation EndTime EndLocation 1 2023-10-15 10:00:00 A 2023-10-15 12:10:00 B 1 2023-10-15 13:00:00 B 2023-10-15 18:00:00 A I want to merge these two rows into one so I get the first StartLocation and the last EndLocation. It should…