Skip to content
Advertisement

Tag: database

Creating specific size

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

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 with no luck. As well, I’m not sure if

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 – Order_id Customer_id product_id Quantity order_date 00001 ABCD B019 7 2020-01-01 00002 ABCD B019 6 2020-05-23

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 in stock. i have this working, but it only returns drink_id. I want it

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 need to have both gin and tonic in stock. If I only have

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 foreign key thorough which I can access Room. But My

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 2 toClient

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

Advertisement