Title: problem with limit in query
Last modified: August 21, 2016

---

# problem with limit in query

 *  Resolved [isk](https://wordpress.org/support/users/nevisan/)
 * (@nevisan)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/problem-with-limit-in-query/)
 * hi Claudio,
    When i use bellow query: SELECT datetime, gold_ask, gold_bid FROM
   wp_felezat ORDER BY datetime ASC LIMIT 200 Its work fine until data recorded 
   in table less than 200 records. But when records in table greater than 200 records,
   in this case chart display 200 record from first of data in database.
 * thanks,
    Omid
 * [https://wordpress.org/plugins/wp-business-intelligence-lite/](https://wordpress.org/plugins/wp-business-intelligence-lite/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [claudio](https://wordpress.org/support/users/calberti/)
 * (@calberti)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/problem-with-limit-in-query/#post-5109951)
 * Hi Omid,
    I’m not sure I understand. When you use limit you are limiting the 
   result to the first N records. So the behavior seems correct. Have you tested
   your query in a SQL editor? What’s your expected result?
 *  [claudio](https://wordpress.org/support/users/calberti/)
 * (@calberti)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/problem-with-limit-in-query/#post-5110005)
 * Since I got no more news I’m closing this issue.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘problem with limit in query’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-business-intelligence-lite_eae8f9.
   svg)
 * [WP Business Intelligence Lite](https://wordpress.org/plugins/wp-business-intelligence-lite/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-business-intelligence-lite/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-business-intelligence-lite/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-business-intelligence-lite/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-business-intelligence-lite/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [claudio](https://wordpress.org/support/users/calberti/)
 * Last activity: [11 years, 8 months ago](https://wordpress.org/support/topic/problem-with-limit-in-query/#post-5110005)
 * Status: resolved