Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re: Limit results of a DBI query

by Ryszard (Priest)
on Jan 29, 2003 at 07:08 UTC ( #230872=note: print w/replies, xml ) Need Help??

in reply to Limit results of a DBI query

A neat trick in Oracle (I dont know if MS-SQL supports "rownum" (or inline views)) is
select column1 from ( select column1, rownum from table 1 ) where rownum > ? and rownum < ?

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://230872]
[Corion]: Your Mother: I think that's because (in the west) the Nazi-Germans are recognized as universally evil. Of course, you could do some number games to calculate other measures of evil than "historic losers of second world war" to come up with other evils:)
[Corion]: I've heard "Troll" described as the new Punk, and in a way, it can be as destructive as living the Punk lifestyle, and you don't have to sit out in the cold...
[LanX]: Anti-Germans
[LanX]: Socrates was a Troll
[Your Mother]: It's very, very dangerous... Thinking that a group is intrinsically evil... buries the fact that all humans can be so deep that it starts to become likely they will be.
[Your Mother]: LanX++
[Corion]: (also the "troll for trolls sake" could seen be much like the "punk for punks beer")
[Your Mother]: I'm completely (historically anyway) a troll in real life. It's not fun online, you can't really win. :P
Happy-the-monk orders a Punk IPA.
[Your Mother]: Also, I'm too old to start fights with strangers anymore.

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (17)
As of 2018-03-19 13:43 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (240 votes). Check out past polls.