<div>
See <a href="http://www.isug.com/Sybase_FAQ/ASE/section6.2.html#6.2.12" rel="ugc">http://www.isug.com/Sybase_FAQ/ASE/section6.2.html#6.2.12</a>
</div>


See http://www.isug.com/Sybase_FAQ/ASE/section6.2.html#6.2.12 [http://www.isug.com/Sybase_FAQ/ASE/section6.2.html#6.2.12]

<div>
Am a beginner, and am not understanding that.<br />
<br />
Can you please write a simple code snippet for <br />
select 10 to 20 records from emp table.<br />
<br />
<br />
Appreciate your help
</div>


Am a beginner, and am not understanding that.

Can you please write a simple code snippet for
select 10 to 20 records from emp table.


Appreciate your help

<div>
Hi Bret,<br />
<br />
Thanks for this solution. It is working greatly. But this would lead me to write procedure.<br />
I need a sql query for this. And I can call that query from my application(java appliction).<br />
<br />
Thanks,<br />
Ganne
</div>


Hi Bret,

Thanks for this solution. It is working greatly. But this would lead me to write procedure.
I need a sql query for this. And I can call that query from my application(java appliction).

Thanks,
Ganne

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
Can you please help to wrtie a query in sybase database.<br />
<br />
For example result Select * from emp returns 100 rows.<br />
I need queries to display first 1 to 20 and another query to display 20 to 40 etc.<br />
<br />
Please help me on this.<br />
<br />
Thanks,<br />
Ganne
</div>
</div>


Hi Experts,

Can you please help to wrtie a query in sybase database.

For example result Select * from emp returns 100 rows.
I need queries to display first 1 to 20 and another query to display 20 to 40 etc.

Please help me on this.

Thanks,
Ganne

Sybase Sql Query for displaying 10 to 20 records (pagination)

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.