|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
September 14th, 2004, 08:49 AM
|
|||
|
|||
between and in search condition
hi,
if i use the following query, isn't it supposed to output same amount of records? select... from... where invoice.billcycle in (104,204,304) and select ... from ... where invoice.billcycle between 104 and 304 for some reason, i get 38 from the first and 7 from the second query. thanks for the help in advance
|
|
#2
September 14th, 2004, 12:34 PM
|
|||
|
|||
|
Code:
c in (104,204,304) is a shorthand for Code:
(c = 104 or c = 204 or c = 304) while Code:
c between 104 and 304 is a shorthand for Code:
(c >= 104 and c <= 304)
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > between and in search condition |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
