How to find rows in one table that have no corresponding row in another table

by 
select tableA.id from tableA left outer join tableB on (tableA.id = tableB.id)
where tableB.id is null
order by tableA.id desc

If your db knows how to do index intersections, this will only touch the primary key index

More Related Contents:

  1. SQL Server indexes – ascending or descending, what difference does it make?
  2. Fastest way to remove non-numeric characters from a VARCHAR in SQL Server
  3. MySQL not using indexes with WHERE IN clause?
  4. What are your most common sql optimizations?
  5. SQL: How to properly check if a record exists
  6. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  7. SQL query that gives distinct results that match multiple columns
  8. How to Optimize Queries in a Database – The Basics
  9. Measuring Query Performance : “Execution Plan Query Cost” vs “Time Taken”
  10. How in H2DB get sql dump like in MySql?
  11. Get the mentioned output by SQL query
  12. Decrease salary using a SQL query
  13. Reason for Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause [duplicate]
  14. ORA-12560: TNS:protocol adaptor error
  15. Select statement to find duplicates on certain fields
  16. How to use DISTINCT and ORDER BY in same SELECT statement?
  17. Getting only Month and Year from SQL DATE
  18. Does MS SQL Server’s “between” include the range boundaries?
  19. basic recursive query on sqlite3?
  20. What is a self join for? (in english)
  21. Check for file exists or not in sql server?
  22. How to ORDER BY a SUM() in MySQL?
  23. How to create a PivotTable in Transact/SQL?
  24. How to split comma-separated values?
  25. What is Full Text Search vs LIKE
  26. SQL – Inserting a row and returning primary key
  27. How to return default value from SQL query
  28. Is this a good way to model address information in a relational database?
  29. Conditional aggregation performance
  30. Retrieve Oracle last inserted IDENTITY

Leave a Comment