http://www.penny-arcade.com/comic/2004/03/24
http://www.penny-arcade.com/comic/2004/04/07
http://www.penny-arcade.com/comic/2004/11/24
http://www.penny-arcade.com/comic/2005/09/05
2.22.2006
2.14.2006
2.10.2006
2.09.2006
2.06.2006
2.02.2006
SQL for Oracle equivalent of MySQL's LIMIT clause
FROM: http://rifers.org/blogs/gbevin
select * from (
select query.*, rownum rnum from (
select table1.column1, table1.column2, … from table1, table2, … where … order by ...
) query where rownum <= 200 )
where rnum >= 100 order by rnum
Subscribe to:
Posts (Atom)