I have a table in html.I want to add that table with php on my database. The problem is with my table. I have done that I have 24 positions and that I want to give in my table that those 24 are that size,not 25 and going on..Second,I have B and R that it is the color (It is
Tag: database
Displaying multiple database tables in one table
I have multiple databases with the same table (an Eventlog with different values). The names of these databases are subject to change. I am trying to display the Eventlog tables in one consolidated table with the corresponding database name. I tried to using cursor and dynamic SQL statement to achieve this wi…
SQL Query Challenge. Divide by Subquery returning ‘Subquery returned more than 1 value.’ error
I have the following table in which I have two sales orders and each sales order has a different number of transactions. SaleOrder Transaction Amount Tax Delivery Charge TotalTax (Including Tax of Delivery Charge) S1 T1 12 0 3 5.5 (This also includes Tax in Column 4) S1 T2 27 4 3 5.5 S2 T1 15 2.5 5 6 S2
SQL query to get Most Frequently purchased and Most Recently purchased quantity for a customer-product pair
I have a table Customer_Order_Data with these columns: customer_id order_id product_id quantity order_date For all the dataset available I want to find out the most frequently purchased quantity and most recently purchased quantity for a customer-product pair. Let’s say I have the following data –…
Select from multiple tables with group and join
i have 4 tabels drinks, opskrifter, ingredients and stock the tables consist of drinks drink_id name beskriv glas image alcohol opskrifter drink_id ingredient_id quantity ingredients ingredient_id name stock ingredient_id name i want a query to select drinks that can be made in opskrifter of the ingredients i…
Return only recipes that contains all ingredients Sql
I have these 3 tables: Drinks drink_id name Ingredients ingredient_id name Opskrifter drink_id ingredient_id quantity Drinks and Ingredients are cross-referenced in opskrifter. I want to return all recipes from opskrifter that have ingredients from another table called Stock name So to make a gin and tonic, I…
Access Values from a customer table to a room type table
I’m Stuck in the middle of my MySQL project. Basically for now I have three tables Room_Type, Room, Customer. Read my code for Room_Type Table and in Room Table, there’s a foreign key through which I can access its room_type (Standard, deluxe, etc) and in the customer table, there’s a foreig…
Query items from a history table
I have a “library” history table (Excel like) to see where a book was or is. id date book action client 1 2020-12-01 1 toClient 1 2 2020-12-02 1 returned 1 3 2020-12-03 1 toClient 2 4 2020-12-04 2 toClient 2 5 2020-12-05 3 toClient 1 6 2020-12-06 3 returned 1 7 2020-12-07 2 returned 2 8 2020-12-08…
joining same table multiple times in Oracle
Hi I am tuning one legacy code. we have below 2 tables in a big query. I have seen in from clause first table has been used thrice and it has been outer joined with same column with same table. Can above 3 lines be handled using fnd_currencies table only once. is there any smarter way to do that? Answer
Generating dynamic data using join select query in Oracle
We have a select query containing around 10 tables. using that query we are getting just 50 record. We need to get 50k record. actually we dont have functional understanding to generate data into these tables. Is there any possibility, we can create insert query to insert data into these 10 table using that s…