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

    odbc limit data load within sql-clause

    clark meyers



      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.





      FROM "user"."configuration_table"

      WHERE "system_date" = '01.01.2017'