Re^4: Ranking position in a SQL index (vairants of limit:sybase)

Sybase does it via a variable called 'rowcount'. So you say

set rowcount 100
select * from foo
[download]

But there is no way to do the equivelent of the skip feature of limit to the best of my knowledge. You'd have to manage it through ids and a where I think. I agree that 'limit' is one of a small set of things I like more about MySQL than Sybase. At least insofar as the MySQL that PM uses is the comparison I much prefer Sybase. :-)

---
demerphq

_{First they ignore you, then they laugh at you, then they fight you, then you win.

-- Gandhi

Flux8}

Comment on Re^4: Ranking position in a SQL index (vairants of limit:sybase) Download Code

Replies are listed 'Best First'.

Re^5: Ranking position in a SQL index (vairants of limit:sybase)
by mpeppler (Vicar) on Oct 05, 2004 at 19:35 UTC

select ... from big_table limit 1000000, 1000010
[download]

should

On the other hand if you use a WHERE clause the server can limit the IO to the correct pages of data...

I have implemented versions of LIMIT by using a temporary table with an identity column, something like:

set rowcount 10010
select pk, id = syb_identity(10) into #tmp from big_table where some_c
+ondition
select b.* from big_table b, #tmp t 
 where t.pk = b.pk
   and t.id >= 10000
set rowcount 0
[download]

Michael

[reply]
[d/l]
[select]


Pathologically Eclectic Rubbish Lister
	PerlMonks