Kevin Murphy

Kevin Murphy

Philip Greenspun's Homepage : Community member

A member of the Philip Greenspun's Homepage community since February 10, 2003

If you were to log in, you'd be able to get more information on your fellow community member.

Static Page Comments

February 10, 2003, on Complex Queries:
Another example of using MINUS is shown in the following crazy-looking (and Oracle-specific [1]) query which selects the 91st through 100th rows of a subquery.
```
with subq as (select * from my_table order by my_id)

select * from subq 
where rowid in (select rowid from subq 
                where rownum <= 100 
                    MINUS
                select rowid from subq
                where rownum <= 90)
```
[1] The Oracle dependencies in this query are rowid and rownum. Other databases have other means of limiting query results by row position.