I have recently enabled IIS by going to the Add/Remove Programs option in the Windows Control Panel and enabled IIS via the “Turn Windows features on or off” checklist. I also want to install PHP for Windows on the same…
I need help for performance this query SELECT * FROM transactions WHERE created_at BETWEEN '2022-08-25 01:03:21' AND '2022-12-13 01:03:21' AND ((transaction_reason IN ('ORIGINAL','REVERSAL_OF_ADJUSTMENT') AND type = 'DEPOSIT') OR (transaction_reason IN ('ADJUSTMENT','REVERSAL_OF_ORIGINAL') AND type = 'WITHDRAWAL') ) ORDER BY transaction_id ASC…
I am working with a JDBC and am trying to figure out how to dynamically create queries - which is proving to be a rather challenging feat. What input can I put in a SQL query to have it return…
I have a many to many relationship between Users & Courses with a pivot table, Users_Courses, containing an isComplete value, but i can't seem to retrieve the isComplete value without looping through every user, getting their courses and then looping…
I have a table "nasypka", with structure: ID|datetime |height|refilled 1 |2022-09-01 12:00|101 |1 2 |2022-09-01 12:01|96 |0 3 |2022-09-01 12:02|50 |0 4 |2022-09-01 12:03|10 |0 ... 50|2022-09-05 17:04|105 |1 51|2022-09-05 17:05|104 |0 ... 80|2022-09-15 10:04|99 |1 81|2022-09-15 10:05|98 |0 This…
I need to find all Users that belong to a certain Country (ID = 4321). But a User's Location can have... EITHER a City OR a Cityaddition, as you can see in... The database schema: User -< Locations >- City…
I want to get latest records of the table with some settings_ids. id settings_id added_date 1 7 2022-08-23 01:44:24 2 9 2022-08-23 01:44:24 3 11 2022-08-23 01:44:24 4 7 2022-08-25 01:44:24 5 9 2022-08-25 01:44:24 6 11 2022-08-25 01:44:24 7…
I would like to use a division query to have all the customers who bought all products. The template is the following : SELECT * FROM Customers AS A WHERE NOT EXISTS ( SELECT * FROM Products AS B WHERE…
I need to make a query that selects a grouped collection of rows from a table based on user input conditions, and then in the select i will sum data from a subset of the rows. The setup is rather…
I have this 3 tables and I want to get the same subjects by given student_id For example I will select Vince (student_id = 1) And Jane (student_id = 3) the return value should be the subjects english and science.