I am having an issue filtering a Mariadb query through HAVING on a computed column based on a Mariadb variable. I am having an issue in Laravel Elquent where a query I am running is producing no results. I have…
I have 3 tables : accounts, contacts, contact_activity. Accounts can have multiple contacts, also multiple activities whereas contacts can also have multiple activities. adding tables queries below: CREATE TABLE `accounts` ( `id` int(10) UNSIGNED NOT NULL, `companyName` varchar(255) COLLATE utf8mb4_unicode_ci…
I made a delete query to delete all records in tbljournaalposten where the field volgr occurs more than once. delete from tbljournaalposten where tbljournaalposten.ID in( SELECT tbljournaalposten.ID FROM invoerdatum INNER JOIN rabobank2_2 ON rabobank2_2.IBAN_BBAN = invoerdatum.IBAN_BBAN INNER JOIN tbljournaalposten ON…
Trying to select earliest order_date for each customer_id. Using following query SELECT customer_id, order_date FROM Delivery GROUP BY customer_id HAVING MIN(order_date) = order_date But those customer_id with more than one order_date rows are not showing in the result. For example…
I have a MySQL table containing users, files and file ages as shown below. Users Files File age A 1 42 A 2 17 A 3 4 B 4 85 B 5 73 B 6 11 C 7 6 C…
MySQL / MariaDB structure: Person | id | |----| | 1 | | 2 | | 3 | Car | person_id | car | |-----------|-------| | 1 | Ford | | 2 | Mazda | | 3 | Ford |…
I have the following table (offer_properties) in MYSQL for an e-commerce website: +----------+-------------+---------+ | offer_id | pkey | pvalue | +----------+-------------+---------+ | 63 | shoesize | shoe_47 | | 63 | sport | walking | | 63 | color |…
I have a table, Account, which I am querying to identify old accounts based on sales records. An account may have multiple rows in a Property table. A property may be closed. If all properties on an account are closed,…
I'm having a bit of trouble with getting a select statement to work correctly. I have the following tables: recipe recipe_ingredient pantry recipe1 ingredient1 Ingredient1 recipe1 ingredient2 Ingredient2 recipe2 ingredient3 I want a select statement that returns recipes when the…
My tables: questions id: serial content: text tags id: serial name: text questions_tags question_id integer tag_id integer I need to select all questions with tag 'css', but don't remove all other tags from JSON from jsonb_agg(). I have this SQL…