Linked Questions

Possible Duplicate: What's the difference between NOT EXISTS vs. NOT IN vs. LEFT JOIN WHERE IS NULL? I need to wite a query that will retrieve the records from Table A , provided that the key ...

I'm trying to get the fastest performance for this DELETE (and SELECT) query. Is there a better way to DELETE the records, because this takes over 10 minutes to run? I imagine it has to do it's own ...

Both of the following queries work perfectly for me at the moment giving out the same results. Which one of the following two are more preferable for huge databases in the long run? Or say, ...

table1 (id, name) table2 (id, name) Query: SELECT name FROM table2 -- that are not in table1 already

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN in MySQL?

Which of these queries is the faster? NOT EXISTS: SELECT ProductID, ProductName FROM Northwind..Products p WHERE NOT EXISTS ( SELECT 1 FROM Northwind..[Order Details] od WHERE p....

I have the following tables: Users Banned SELECT u.* FROM Users WHERE u.isActive = 1 AND u.status <> 'disabled' I don't want to include any rows where the user may also be in the ...

Using MySQL 5.x I want to efficiently select all rows from table X where there is no related row in table Y satisfying some condition, e.g. Give me all records in X where a related Y with foo = bar ...

I want to run a mysql query to select all rows from a table films where the value of the title column does not exist anywhere in all the values of another column (collection). Here is a simplified ...

I want to delete all rows which has no existing foreign key in another table example: table1 +----+-------+ |id | data | +----+-------+ | 1 | hi | +----+-------+ | 2 | hi | +----+-------+ | ...

Let's say I have 2 tables (tb1, tb2) with both the following schema: CREATE TABLE tb1 ( col1 INT NOT NULL, col2 TEXT NOT NULL, col3 TEXT NOT NULL, col4 REAL ); How do I find records of tb1 ...

Let's say I have two identical tables, A and B, with the row "x". I want to select all elements in A, where the value of x in A is not in any value of x of B. How do I do that?

I'm optimizing some SQL queries (this could be considered part 2 of a question i recently posted) and replacing some NOT IN with NOT EXISTS predicates Am I right in thinking that the main benefit to ...

I am using Microsoft SQL Server 2008 and we have two tables called Applications and Enrolments. I want to know which applications are not converted into the Enrolments. As shown in the following ...

I have a complex query, but here is the essence of what I'm trying to do In a table looking like this: Col1 Col2 Bill 0 Bill 0 Bill 0 Bill 1 Bill 1 John 1 John 1 Jonh 1 The above ...