In oracle how to output the data portionwise by condition?

Question

Oracle

1. Table (City, Data1 , Data2), 2. Table (City, Quantity) - "Quantity" is simply ROW_NUM for Table1 -va lines for this city. And so on throughout the list

Answer 1

Sorry, I found it myself:

SELECT * FROM(
    SELECT
        ROW_NUMBER() OVER(PARTITION BY CITY ORDER BY CITY) row_num,
        DATA1,
        DATA2,
        CITY 
    FROM TABLE1)t1
WHERE t1.row_num BETWEEN 1 AND (select t2.COUNT from TABLE2 t2 where t1.CITY = t2.CITY);