Hi every one
I have experienced an issue when i try to find any elements among list of elements and i m trying to execute “in” query and if list of elements is more than 1000, query fails to execxute. e.g if i ahve list of user ids and list is more than 1000 . if i m trying to execute query with where clause and use in(……….) , it fails . Does any one find solution related with this .
e.g select * from tablename where tablename.columnName in (list of elements) //// here list of elements is more than 1000.