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…
This is so simple query. I need to update Bookings tables', LinkedBookings column (int array data type) to it's own Id. Below query didn't work for me. update public."Booking" b set "LinkedBookings" = {"Id"} Above is giving below error, SQL…
How to select values in sql with null result For example we have next table user code user1 code 1 user3 code 2 user4 code 4 Select select * from table where user in ( 'user1', 'user2', 'user3', 'user4') Result…