Output student number that exists only on primary key but doesn’t exist on foreign key

by

This way you can select all students that are not found (by their id) in the grade table.

SELECT * 
FROM student 
WHERE id NOT IN (SELECT student_id FROM grade)

More Related Contents:

  1. Get the mentioned output by SQL query
  2. Decrease salary using a SQL query
  3. MySQL query finding values in a comma separated string
  4. Conditional WHERE clause in SQL Server
  5. Concatenate row values T-SQL
  6. MIN/MAX vs ORDER BY and LIMIT
  7. Difference between “read commited” and “repeatable read”
  8. Reference alias (calculated in SELECT) in WHERE clause
  9. Implement paging (skip / take) functionality with this query
  10. Copy data into another table
  11. When to use Common Table Expression (CTE)
  12. SQL server ignore case in a where expression
  13. Find closest date in SQL Server
  14. Get the distinct sum of a joined table column
  15. INSERT SELECT statement in Oracle 11G
  16. Alternate of lead lag function in SQL Server 2008
  17. How to split comma-separated values?
  18. SQL – Select first 10 rows only?
  19. SQL Oracle LEFT JOIN and SUBQUERY error: ORA-00905: missing keyword
  20. What is Full Text Search vs LIKE
  21. SQL – Inserting a row and returning primary key
  22. How do I start auto increment from a specific point?
  23. How to search SQL column containing JSON array
  24. How to use a dynamic parameter in a IN clause of a JPA named query?
  25. Perform regex (replace) in an SQL query
  26. How to create a new database with the hstore extension already installed?
  27. How important are lookup tables?
  28. Finding unmatched records with SQL
  29. Hierarchical Queries in SQL Server 2005
  30. how to use LIKE with column name

Leave a Comment