I am querying a really big view (more than 100 columns, more than 100 million rows),
when running distinct on one column with restrictions in WHERE clause, it returns 200 rows.
However, when running the same query (same WHERE clause) with "top 10 * " it returns 0 rows.
Any idea? I tried both ODBC and Teradata connectivity. Using SQL Assistant.
version of TD: 14.00.04.04a
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.