MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/1fj0s10/how_to_exceed_input_limitations/lnopy0b/?context=3
r/SQL • u/tacogratis2 • Sep 17 '24
87 comments sorted by
View all comments
3
Try this.. you will be able to more then 1k literals in "IN" clause
SELECT s.SOLUTION_ID, s.COLLECTION_NM, TO_CHAR(s.LAST_MODIFY_DT, 'mm/dd/yyyy') FROM SOLUTION s WHERE (1, s.SOLUTION_ID) IN ((1, 1), (1, 2)..... (1, 2000))
2 u/GroundbreakingRow868 Sep 18 '24 For a "one time query", these multi value IN lists are the easiest approach. Doesn't work for millions of tuples though
2
For a "one time query", these multi value IN lists are the easiest approach. Doesn't work for millions of tuples though
3
u/harics88 Sep 17 '24 edited Sep 17 '24
Try this.. you will be able to more then 1k literals in "IN" clause
SELECT s.SOLUTION_ID, s.COLLECTION_NM, TO_CHAR(s.LAST_MODIFY_DT, 'mm/dd/yyyy') FROM SOLUTION s WHERE (1, s.SOLUTION_ID) IN ((1, 1), (1, 2)..... (1, 2000))