Re: How can I retrieve rows from 11 to 20 ( Selete TOP 10 gives first10)

ghetto_banjo

Guest

Posts: n/a

12th Apr 2010

Something like this will get the job done. I don't know your table/
field names...

SELECT TOP 10 primaryKey FROM myTable
WHERE primaryKey NOT IN (SELECT TOP 10 primaryKey FROM myTable ORDER
BY....)
ORDER BY ...

« Printing PDF Files in Order | Graphs and charts in Access 2007 »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RE: How can I retrieve rows from 11 to 20 ( Selete TOP 10 gives first	KARL DEWEY	Microsoft Access Forms	3	13th Apr 2010 06:03 PM
one app gives smooth video, one gives jerky	njem	Windows XP General	9	3rd Nov 2009 05:05 AM
Syncing to iPAQ sometimes gives me blank songs - what gives?	=?Utf-8?B?RWQ=?=	Windows XP Music	0	7th Sep 2005 01:06 AM
Installing VC-7 gives stops working of VC-6 (gives linker error)	R Tamilarasan	Microsoft Dot NET	0	30th Jul 2004 01:55 PM
Making rows fixed so when you scroll down you still see top rows.	Lisa	Microsoft Excel Misc	2	9th Jul 2003 11:11 AM