Top Function in TeraData
Posted on 2006-06-22
I am having trouble getting the top 10 rows in Teradata.
This is been complicated by a couple things:
1. I don't have permissions to create a temporary table.
2. I am using a group by function in the query.
3. I am joining to other tables in the query.
I have tried to use sample but have had problems because of joining to other tables. Maybe, I don't have the syntax correct- I just put it right before the from clause. Also, I tried the cum function, but had problems because I am using a group by.
I have asked a question similar to this before; however, this time I have the complicated factors mentioned above.