What is the statement to select limited values?
How to select the some of numbers in same column
if I have in column B these values :500-200-50-60-100
and I use this statement
Select A,B,C,D FROM TABLE1 Where B between '300' and '55 '
the result is: 500-50
and if I use this statement:
Select A,B,C,D from Table1 where B>=55 and B<=300
the result is: 500-50
and as I know the result must be like this:200-100-60.
How to do this/
|