in reply to fetch row or fetchall

You could use TOP.

Select TOP 100 * from table

Rupesh.

Replies are listed 'Best First'.
Re^2: fetch row or fetchall
by jfroebe (Parson) on Nov 10, 2004 at 05:04 UTC

    TOP is not ANSI standard SQL... meaning that its use is limited to those dbms's that have this extension.

    Team Sybase member

    No one has seen what you have seen, and until that happens, we're all going to think that you're nuts. - Jack O'Neil, Stargate SG-1