sql - 我需要从表中选择所有记录，而不是通过子查询选择的记录，但它再次返回所有记录

Question

Select * from Loan
where EXISTS (Select * from Loan where Loan_No != 'A1234')

标签： sql

Answer 1

如果您想选择带有 loan_no != 'A1234' 的记录，只需使用以下命令：

select * from loan where loan_no != 'A1234'

如果您想选择没有在子查询中选择的记录的记录，请使用以下命令：

select * from loan where loan_no not in (select loan_no from loan where XXX)