티스토리 뷰

공부

[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

'공부' 카테고리의 다른 글

[Spark] submit configuration  (0) 2019.06.30
[Git] In a Git repository, how to properly rename a directory?  (0) 2019.06.30
[Regex] start word ... end word  (0) 2019.06.30
[Linux] vi  (0) 2019.06.30
[Java] shuffle  (0) 2019.06.30
댓글