티스토리 뷰

공부

[SQL] not exists

승가비 2020. 6. 7. 16:22
728x90

https://stackoverflow.com/questions/173041/not-in-vs-not-exists

 

NOT IN vs NOT EXISTS

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.

stackoverflow.com

 

728x90
댓글