selecting the first 7 out of 1000 rows. How can i do this?

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ste_P SSCarpal Tunnel Points: 4430 More actions · Answer 1

SELECT TOP 7 *

FROM tblNames

WHERE (PK > 10)

Have Fun

Steve

We need men who can dream of things that never were.

LANRE OLUDE SSC Rookie Points: 45 More actions · Answer 2

thanks. 'select Top 7' works for MS Access database, but it doesn't work for a Sybase engine.

who can help further pls?

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

check this link from sybase's site

they use top 7 just like in sql server... maybe you can search more on their site :

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

Please refrain from multiposting! That makes it hard to follow.

You are aware that this here is SQL Server Land?

Apart from the link Remi posted, you might have better luck at http://www.dbforums.com.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]