I am trying to use a max(..) to get the maximum value from a set, but I want to also get the other row values that correspond to this row (or rows if there are multiple rows that match the…
for the below code, I have deleted the hist.game_hist table from db. Now, according to the code below, I want my code to pickup the else condition and avoid going into the then condition (as game_hist does not exists, it…
I have a table with data on activated subscriptions in PosgreSQL database. The table has the following columns: User ID, Start Date of Subscription, End Date of Subscription, and Type of Subscription. If a subscription is currently active, then the…
If a slot is recurring it happens at the same time each week. How would I fetch records scheduled later in the day, week, or month, considering the current date and time? I am using MySQL. My current query is…
TL;DR Base table is incorrect, need to refine data using query. Final value is incorrect (slightly less) as nesting on itself leading to some records omission as it's a partial join. Detail- This is a query that I am trying…
I am trying to search my database for a wide range of values. And get all the users that match the criteria but not get the same user if it machtes multiple critearia. I think the problem in my code…
CREATE TABLE Bagel ( BagelID CHAR(2) NOT NULL, BagelName VARCHAR(30), BagelPrice DECIMAL(4,2), BagelDesc VARCHAR(30), PRIMARY KEY (BagelID)); CREATE TABLE Customer ( CustID INT NOT NULL, FirstName VARCHAR(30), LastName VARCHAR(60), Address1 VARCHAR(60), Address2 VARCHAR(60), City VARCHAR(30), State CHAR(2), Zip INT, MobilePhone…
I'm starting to study MySQL and I found in one of my resources the use of the command: Alter table tableName modify(....) Instead of using 'modify column' It it valid to use it and if it's I want some. I…
I have data in table as below: Account Id Amount Start_date End_date 123 10 2023-11-16 17:00:00 2023-11-16 18:00:00 123 10 2023-11-16 02:00:00 2023-11-17 02:00:00 123 20 2023-11-17 17:00:00 2023-11-17 18:00:00 123 30 2023-11-18 02:00:00 2023-11-20 02:00:00 123 10 2023-11-18 17:00:00…
I have a SQL query which works but is slow. I wondered if there is a more efficient way to express it using joins. Scenario: Tables: productions, scripts and a join table, productions_scripts productions id (int) production (text) scripts id…