I would like to try to fetch “all employees names that sold all books”: I’ve tried this: SELECT title FROM books l1 WHERE l1.id NOT IN ( SELECT l2.id FROM books l2, purchases p WHERE (l2….

I have a basic parent / child scheme for expenditures: The underling data is the same so I just added a category column and parent_id. These have child records: I am trying to aggregate the totals …

A select SQL with a subquery that contains a descending sort and inner join to link unto saem id (patid). Once this sort subquery is done I will make it a view query to be used by another SQL which is …

I am working on a procedure to automate some inserts based on an IN parameter. I also want to know if the inserts fail or not, so I created an exception that returns me a ‘FAIL’ if any error occurs. I …

I have an ASP.NET page which repeatedly calls a SQL stored procedure that pulls a random userID from the table Hearings_Users. What I need now is to pull each UserID in successive order. I would go …

I have written query which should fetch ADJUSTMENT_AMOUNT and PAY_AMOUNT from the table ABC for different month, I have used subqueries to get this done, each ADJUSTMENT_AMOUNT and PAY_AMOUNT …

Given that I have the following tables (datasets) made by python: import pandas as pd dic ={ “ID”:[1,2,3], “patient_ID”:[100,200,300], “Year”:[2007,2008,2012], “month”:[8,6,3] } …

I have this data: And, I am trying to compare that one of the date is within range of the given data, but without any success. Here is my query: SELECT * FROM tbl_emp_leave_details WHERE emp_id …

i came up by visiting this question. so i made a query like this SELECT ru.iUserId,ru.iRefUserId,CONCAT(ru.vName,ru.vLastName) AS userName,CONCAT(iru.vName,iru.vLastName) AS RefUserName FROM `…