I'm hurting for an answer on this one. I'm not great at SQL just yet, but I'm trying to write a select statement that finds dates within a certain range. My problem, I think, is that the date values are…
I want to retrieve yesterday's record in an exact hour and minute time For example, this is today's date and time 2023-04-22 14:32:15 I want the records in 2023-04-21 14:32:15 I tried some queries but non of them works for…
How do I go about making the in_date's end date always based on the previous week's last date? For example today is 24 April 2023, and the previous week's (Mon to Sun) last date was 16/04/2023 Expected SQL Query: SELECT…
When using a custom SQL query with Prisma, I keep getting the following error when trying to pass an array of numbers to the IN parameter. Converting it to a string of comma seperate values also doesn't work. The home_tryscorer_ids…
good greeting I have a PHP query that brings data, name, and department into a table, how can I split into tables by departments, which means each department is in a table $employee_qry=$conn->query("SELECT * FROM `employee` ") or die(mysqli_error()); while($row=$employee_qry->fetch_array()){…
I want to make the code that if any of new column's value is null change that one to the value of row before with trigger event CREATE TRIGGER updateField BEFORE INSERT ON message FOR EACH ROW IF (NEW.COLUMN IS…
Ahh...been banging my head against this because I cant seem to figure it out. My tables: $ select * from my_family_members; +-----------+-----------+-----------------------------+ | member_id | house_id | member_name | +-----------+-----------+-----------------------------+ | 2 | 2 | Ash | | 5 |…
I need an SQL query for the next question. For example I have a table: | id | element | dt | | -------- | -------- | -------- | | 1 | a | 22/04/22 | | 2 | a…
I have a Postgres DB with multiple databases, whose schemas are owned by individual service users. Now, I want to create a user which can access all those databases/schemas with atleast SELECT permissions. Is there any effective way of assigning…
I have a table with orders (for each order (transaction_id) there are client_id and item_id and quantity) I need to find completely identical orders for a set of goods and their quantity in the order CREATE TABLE IF NOT EXISTS…