SQLite dropping rows from result of select

For example I execute SELECT query which result is set of rows R. Is any way to drop from R rows that satisfied condition which depends on last row of R? Before executing SELECT query the condition is unknown. I thought about some PROCEDURE but i can't write it :(. Anyone can help? :).