Suppose the following data: user_id timestamp value -------------------------- 2983 2022-01-01 12:01 100 2983 2022-01-01 12:04 106 2983 2022-01-01 12:06 101 2983 2022-01-01 12:10 110 2983 2022-01-01 12:11 112 2983 2022-01-01 12:13 115 2983 2022-01-01 12:15 102 I'm trying to perform…
Before using parameters FDQuery.Connection := FDConnection1; FDQuery.SQL.Text := 'SELECT * FROM ' + symbol + ' WHERE date >= ''' + datetostr(Dfrom) + ''' AND date <= ''' + datetostr(Dto) + ''''; FDQuery.Active := True; it can work, but after…
I am trying to create a relationship between categories and products. I have provided the various columns for both tables and I am trying to link them using a foreign id (the category_id from the category table) but I keep…
I have a table where we have barcodes and order numbers, so, I am trying to find all the barcodes that are being assigned to multiple orders. Example table barcode ord_no 1233 1 1234 2 1233 3 1235 4 1236…
I have in my postgres database, the following table: CREATE TABLE trips(id int, lat_init double precision, lon_init double precision, lat_end double precision, lon_end double precision); INSERT INTO trips(id, lat_init, lon_init, lat_end, lon_end) VALUES (1,53.348060,-1.504068,53.360690,-1.457364), (2,53.427651,-1.355329,53.380441,-1.536918), (3,53.365660,-1.497837,53.363838,-1.388023), (4,53.380349,-1.460028,53.429298,-1.359443), (5,53.345526,-1.449195,53.407839,-1.501819); So that…
I have 3 tables vendors, components and catalog, here is the schema: vendors - vid,vaddress,vname components- cid, cname, type catalog- cid, vid, cost catalog is connected with the 2 tables with a foreign key vid and cid. Query: select vid…
Grouping items by their category works but its not placing all the products of the category in one optgroup but repeating it. All the items should be in one group not separate as an duplicate group. <select style="width: 25%;" name="item[]"…
Say, there is a table A, with columns a and b, both are int type with unique index. I want to select from A where if there a tuple whose a equal to 100, then return this tuple otherwise, return…
I'm practicing for my upcoming SQL interview using questions from bigtechinterviews.com and am currently stuck on my solution (See my solution below). Prompt: Write a query to find active users on the Free plan to contact them 1 day before…
Project: bookable activity Error: Undefined variable $days Description: creating mini-eshop which you can choose if you want to go for riding, doing arts or do guided tour. User have to choose 3 of the activities by choosing time and day…