Suppose the table is: employee_id branch role 1 A admin 2 A engineer 3 A finance 4 B admin 5 B finance 6 C engineer How can I find the departments that do not have all the roles? In this…
I have a repayment table that looks like this below, cus_id due_date principal disbursed_date 1 01-01-2022 10 01-11-2021 1 01-02-2022 10 01-11-2021 1 01-03-2022 10 01-11-2021 2 15-03-2022 20 15-02-2022 1 01-04-2022 10 01-11-2021 3 01-04-2022 15 20-03-2022 2 15-04-2022…
I have been having issues with a query that I am creating to search for books in a system, I am searching for a keyword in all columns in a table. It could be anything and I need it to…
How can I make an SQL query to select records that do not have at least one child element? I have 3 tables: article (~40K rows), calendar (~450K rows) and calendar_cost (~500K rows). It is necessary to select such entries…
So i have table Project --------------------------------- project_id | name| --------------------------------- 1 | project 1 | 2 | project 2 | --------------------------------- table 02 report ---------------------------------------------------- report_id | report_emp | report_hours |report_project_id| --------------------------------------------------- 1 | 1 | 5 | 1 |…
I have a table with 5 columns. id bday update restartDate startDate I need to update each rows update column with the most recent date between restartDate and startDate I've tried: update mytable set update = (select MAX(v)from (values (restartDate),(startDate))…
My table has 650M rows (according to a fast but decently precise estimate from a query I found here). It has a text column called receiver_account_id, and I need to be able to search those records like: r.receiver_account_id LIKE '%otherWordsHere'.…
I have a table Table name - commands id name status group_id id - number name - string status - 0 or 1 group_id - number I need to sort as follows: for all elements with the same group_id I…
I have this problem where I want to first select 8 elements from a mysql database ordering by id DESC. Then I want to select another group of results (8 items), this time order by date DESC but the results…
I have Categories stored in a single table. Where there is no limit on number of childerns. I want to fetch all the linked childern categories for the provided category id: The reason for getting the hierarchy is that I…