<div>
Hi,<br />
IN Clause will expensive for this kind of query.. Pls use one of the option below-<br />
<br />
<b>Option1....</b><br />
<br />

<pre><code id="code-20-41920694-1">SELECT * FROM STUDENTS 
WHERE ID BETWEEN 100 AND 500</code></pre>
<br />
<b>Option2....</b><br />
<br />

<pre><code id="code-20-41920694-2">SELECT * FROM STUDENTS 
WHERE ID&gt;= 100 AND ID&lt;=500</code></pre>
<br />
<b>Option3.... Generate Number and join like below</b><br />

<pre><code id="code-20-41920694-3">SELECT DISTINCT s.*
FROM Master..Spt_Values v INNER JOIN STUDENTS s
ON s.ID = v.number
WHERE Number &gt; 0 AND Number &lt;= 500</code></pre>
<br />
Hope it helps !!
</div>


Hi,
IN Clause will expensive for this kind of query.. Pls use one of the option below-

Option1....



SELECT * FROM STUDENTS 
WHERE ID BETWEEN 100 AND 500


Option2....



SELECT * FROM STUDENTS 
WHERE ID>= 100 AND ID<=500


Option3.... Generate Number and join like below


SELECT DISTINCT s.*
FROM Master..Spt_Values v INNER JOIN STUDENTS s
ON s.ID = v.number
WHERE Number > 0 AND Number <= 500


Hope it helps !!

<div>
<div class="content wysiwyg-content">
How to select all rows from the STUDENTS table where the ID number is any number from 100-500? Do I use in or between
</div>
</div>


How to select all rows from the STUDENTS table where the ID number is any number from 100-500? Do I use in or between

In or Between

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

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.