If you want to limit the results of a query to see the first 1000 where order by matters than you might use a sub-query technique additionally.
SELECT *
FROM (SELECT t1.ID, t2.name, t3.gender, t4.Age
FROM Table1 t1
INNER JOIN table2 t2 ON (t1.ID = t2._ID)
INNER JOIN table3 t6 ON (t1.ID = t3.ID)
INNER JOIN table4 ON (t1.PARTY_ID = t4.PARTY_ID)
Order by t1.PARTY_ID)
WHERE ROWNUM <=1000;
... View more
