공부

[SQL] IN () Max count

승가비 2019. 6. 30. 01:15
728x90
SELECT * FROM table WHERE id IN ( 1, ..., 1000 ) -- maxCount is 1000

SELECT * FROM table WHERE id IN ( SELECT * FROM id_table ) -- infinity

[출처] https://gent.tistory.com/142

728x90