illogical answer set

Database
Teradata Employee

illogical answer set

Hi,

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

Thanks&Regards,

Tomas