Query Table

Hi,
I tried to create a query table using one of the columns in the table in the WHERE clause. However, when I execute the query not all rows are retrieved. I tried View Mode as well as Refresh - the result is just the same. I get only 10 matching rows.

How do I accomplish something like this?

Thanks,
Yamini