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…
I have a query to get all penalty data with latest prices. In prices table there are many prices related to a product. To take the valid price I need to get the latest price. Here is the query. SELECT…
I have a table of products and another table of specific listings of these products. CREATE TABLE products (id INT AUTOINCREMENT); CREATE TABLE listings ( id INT AUTOINCREMENT, product INT REFERENCES products(id), vendor INT ) I want to select listings…
I am working with a PostgreSQL database where I have a query that unions 5000 tables with identical structures. The query is saved as a view. I've noticed that the planning time for this query is significantly longer than the…
I've built many queries on my PostgreSQL database, but some of them take a very long time to load, and I'm having trouble understanding why. Especially the one below, which can return a lot of information but uses very simple…
I've a table with ID column, auto increment. Because of the bad migration a while a go, and I only noticed this now, form entries were all stored as ID 0. So now I have two problems: around 1000 entries…
I need to select all records for the current day in CST, however the timestamp fields in the table are all in GMT/UTC. The server's timezone is GMT. Getting all records for the current day in GMT is very fast…