<div>
Here is a sample :<br />
<br />
SELECT TOP 25<br />
FirstName, LastName<br />
FROM Students<br />
WHERE GraduationYear = 1997<br />
ORDER BY GradePointAverage DESC;<br />

</div>


Here is a sample :

SELECT TOP 25
FirstName, LastName
FROM Students
WHERE GraduationYear = 1997
ORDER BY GradePointAverage DESC;


<div>
It means that all the record will be sorted descently. <br />

</div>


It means that all the record will be sorted descently.


<div>
Ive tried this using telnet to my sybase server, and i get a syntax error near '25'. I dont think my version of sybase supports that method.<br />

</div>


Ive tried this using telnet to my sybase server, and i get a syntax error near '25'. I dont think my version of sybase supports that method.


<div>
<div class="content wysiwyg-content">
Is there a way to limit the amount of records that are returned by a recordset? Can i set the rowcount in the query and then the RS will only return that amount of records.
</div>
</div>


Is there a way to limit the amount of records that are returned by a recordset? Can i set the rowcount in the query and then the RS will only return that amount of records.

Setting RowCount

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.