problem with limit in query

  • Resolved isk

    (@nevisan)


    11 years, 10 months ago

    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/

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

    (@calberti)

    11 years, 10 months ago

    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

    (@calberti)

    11 years, 8 months ago

    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.