<div>
You can do the restriction in your SQL query. &nbsp;Use 'TOP 5'. &nbsp;You will probably want to have some kind of ORDER BY OR WHERE clause criteria so you can properly identify what records are the top 5.<br />
<br />

<pre><code id="code-20-41762953-1">SELECT TOP 5 MyField
From MyDatabase
WHERE ...
ORDER BY ...</code></pre>
</div>


You can do the restriction in your SQL query.  Use 'TOP 5'.  You will probably want to have some kind of ORDER BY OR WHERE clause criteria so you can properly identify what records are the top 5.



SELECT TOP 5 MyField
From MyDatabase
WHERE ...
ORDER BY ...

<div>
Or (Oracle)<br />

<pre><code id="code-20-41763023-1">Select MyField
FROM MyDatabase
WHERE ....
AND ROWNUM &lt;= 5
ORDER BY  ...</code></pre>
</div>


Or (Oracle)


Select MyField
FROM MyDatabase
WHERE ....
AND ROWNUM <= 5
ORDER BY  ...

<div>
Can you please clarify what you do want? &nbsp;<br />
<br />
You said you want the max 5 results. &nbsp;That is ALL we know. &nbsp;I've given a solution that will give you the max 5 results.
</div>


Can you please clarify what you do want?  

You said you want the max 5 results.  That is ALL we know.  I've given a solution that will give you the max 5 results.

<div>
sure thank you <br />
what i want is that i want when i select a value from autocomplete extender, i need to manage a counter and each time user select a value the counter will be incremented and once it reaches 5 a message will be displayed
</div>


sure thank you
what i want is that i want when i select a value from autocomplete extender, i need to manage a counter and each time user select a value the counter will be incremented and once it reaches 5 a message will be displayed

<div>
thank you it solved my issue
</div>


<div>
<div class="content wysiwyg-content">
i have &nbsp;ajquery autocomplete extender , and i need once i seleect a value i need to select max 5 values.how to do this restriction
</div>
</div>


i have  ajquery autocomplete extender , and i need once i seleect a value i need to select max 5 values.how to do this restriction

jquery autocomplete extender

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

jQuery (Core) is a cross-browser JavaScript library that provides abstractions for common client-side tasks such as Document Object Model (DOM) traversal, DOM manipulation, event handling, animation and Ajax. jQuery also provides a platform to create plugins that extend jQuery's capabilities beyond those already provided by the library.

jQuery

JavaScript is a dynamic, object-based language commonly used for client-side scripting in web browsers. Recently, server side JavaScript frameworks have also emerged. JavaScript runs on nearly every operating system and  in almost every mainstream web browser.

JavaScript

COBOL (Common Business-Oriented Language) is a programming language with English-like syntax. It is readable but verbose compared to other programming languages. CODASYL (Conference on Data Systems Languages) created COBOL in 1959 based on design work from Grace Hopper. It was standardized in 1968. COBOL is still present in large-scale batch processing and transaction processing where legacy applications are being used, usually in government, financial, and administrative systems.