I have a mysql table which has 'username', 'acctstarttime' and 'acctstoptime'(and an 'id') datetime columns. I need to get records that its acctstarttime or acctstoptime between other 'acctstarttime' and 'acctstoptime' records with same username. For example 'John' has 3 records.…
INSERT INTO customer_data (cus_id, cust_name, age, city, salary) VALUES (1, 'Sam', 'Delhi',9000), (2, 'ROhit', 'Banglore', 5000), (3, 'Rahul', 'Mumbai', 12000), (4, 'Sunny', 'Odisha',15000); This is my Code
I have a table below with sample data. | id | type| cycle| datetimestamp | status1 | status2 | |:----:|:---:|:----:|:-------------------:|:---------:|:---------:| | 27 | AN | 123 | 2022-12-28 04:12:31 | Normal A | Normal A | | 27 | AR…
How to create a query SQL for Postresql who select only those people who have never participated in previous events and only once this year, as in the last table below. tbl_evt id_evt evt_date 1 2022-10-01 2 2022-08-05 3 2021-01-01…
I have a MySQL table named users containing simple counts for all users. user_id counter1 counter2 1 0 5 2 1 6 3 2 7 4 3 8 I would like to run a single query that updates the counter1…
I have created an entity tblPerson and from this entity I need to get the bGroup of t.adminID and the bGroup from the d.personID. I have tried the below query but it's not returning anything. ` SELECT t.adminID, p.firstName, p.lastName,…
I have following Postgres query that runs over a large table and whenever it does, I observe a high CPU load that reaches 100% : SELECT id, user_id, type FROM table ss WHERE end_timestamp > CURRENT_TIMESTAMP AND (notification_channel1 = true…
I have this table in PostgreSQL: CREATE TABLE pet ( _id SERIAL PRIMARY KEY, player_id int REFERENCES player(_id), feed_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, num_poop integer DEFAULT 0, clean_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, play_time TIMESTAMP WITH TIME…
I'm working on for presence control. The check-in and check-out are 2 difference records in a table It is possible that somebody does not check-out for several days, but should count as present for the particular day person ID -…
Hope y'all are enjoying the holidays. I am attempting an automated installation of wordpress on my Linux VM using ansible. To that end, I have written this ansible piece of code that tries to mimic the official ubuntu guide. Here…