3 Replies Latest reply: Feb 17, 2017 4:48 AM by Shraddha Gajare RSS

    odbc limit data load within sql-clause

    clark meyers

      hello,

       

      i want to limit the data loaded with a sql-query.

       

      i successfully set up a odbc connection.

       

      the query is very simple, but it does not consider my where-clause.

       

      the resultset is completly different compared doing this query with sql-developer.

      with qlik sense i get far more rows back.

       

      why? can you tell me what's wrong here.

       

      SELECT

      "id",

      "system_date"

      FROM "user"."configuration_table"

      WHERE "system_date" = '01.01.2017'