user287745
Reputation: 3171
How to select records not selected by inner select statement?
select pid from table where pid is not (select top 10 pid from table1)
What is the correct syntax for the above?
Upvotes: 1
Views: 77
Answers (2)
SqlACID
Reputation: 4014
select pid from table where pid not in (select top 10 pid from table1)
Upvotes: 2
Related Questions
- SQL Server: select records, not linked to another table
- How to select rows not present in another table with 2 columns comparison?
- SQL Exclusion in the select query
- how do I select a record which is not present in other related table using sql?
- SQL select where not in select statement
- Select records which does not return from inner join
- Select from table not in another table
- Select rows not in another table, SQL Server query
- SQL: select all records not selected by another query
- SELECT All that are not in another table