How to exceed the limit of 500 numbers in sql query？

[YC_10946483]

Hi everyone.  I want to get all data from my database which  totalNumber  is larger than 500, but the result is only returning 500.  Is there any method to overcome this limit?

[Surya_Tiwari · Accepted solution]

Hi, @YC_10946483  Look at the below community post.

https://community.ptc.com/t5/ThingWorx-Developers/Max-number-of-records-of-SQL-query/m-p/831922#M59993

[YC_10946483]

Hi,@ Surya_Tiwari 

Appreciate for your reply