Topic: How in request to restrict an amount of produced lines depending on value of a column?
FB3. The conditional request:
select t.value, t.edate from t order by 1, 2 desc
For everyone value there are tens/hundreds edate. It is necessary for everyone value to restrict an amount produced edate, for example, to ten. If records for specific value less than ten to produce how many is. Probably? Looked at window functions, first, fetch, anything suitable I do not find. it would not be desirable. Execute block, for select... do would arrange.