I want to ONLY select customers who have purchased both products 22 and 36 Customers Id Email Name 1 [email protected] Jack 2 [email protected] Robin 3 [email protected] Pop Sales Id CustId ProdId Amount 1 1 22 100 2 2 22 100…
I am trying to build an annual leave program. I have two tables the first one stores all the staff data and the second one contains the staff who are on annual leave with their start and end date. I…
I am trying to change column name in SQL but it is showing me error query alter table cust rename column first name to first_name(30) ; error ERROR: syntax error at or near "name"LINE 2: rename column first name to…
How to improve my query where I have used offset in mysql. I am trying to make pagination. I have a database there I have more then 800k data for a single column. Example: My table data like: ----------------------------------- |id…
I'm working in a multi-tenant software to manage inventory of products and I'm having difficulties to create a query to bring products inventory based on quantity criteria. Use case: Bring all products with all their inventory from all warehouses from…
I have price column in MySQL contains this values : price 1020.2200 202.0000 0.5000 820.6700 I want to split at the floating point. Here is what I'm trying to get : price p_units p_decimals 1020.2200 1020 22 202.0000 202 00…
I am getting raw data from a customer which I am loading into a db using a script. As of now, I am storing everything as strings. I have data in this format: 18.02.2024 00:06:09.125. I want to convert the…
I have a query gets opening and closing balances for each month of customers from their transactions and then get a company total for the month. but if a customer does not have any transactions for multiple months i need…
I have an entity that looks like this @Entity @IdClass(AId.class) class A { @Id private String userName @Id @NotNull @JoinColumn(name = "location_id", referenceColumnName = "id", nullable=false, foreignKey = @ForeignKey(name = ...)) private Location location; private String userInformation; } The class…
this is the problem. I have two tables - ps5 and xbox:- id ps5_game John COD Jean GTA Kash COD Don PVZ Trey GOW Nate UC id xbox_game Jarvis UC Carl GOW Damon COD Donny GOW Trav GOW Natty UC…