between two values not working in SQL Query

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

selection range not coming in the sql statement.

SQL

select * from tab1 where startsal between '10' and '89' and Endsal between '2010' and '8800'

nothing will coming for the above condition. but, it is suppose to display all the
values from 10 onwards to 89 and 2010 to 8800
see my data

------------------------
StartSal	EndSal
------------------------
30      	2011
60      	2022
20      	2011
15      	2031
9       	2047
8       	3400
4       	4500
2       	5600
1       	4600
20      	3900
50      	5100
70      	6700
89      	8800

Posted 16-Jan-12 23:10pm

gani7787

Updated 16-Jan-12 23:34pm

v4

Add a Solution

Comments

Selva K 17-Jan-12 5:17am

Your data is between that condition only, Check your question..

Md. Rashim Uddin 17-Jan-12 5:25am

It should work...

Prasad_Kulkarni 17-Jan-12 5:27am

no error

Amir Mahfoozi 17-Jan-12 5:35am

What are the data types of StartSal and EndSal ?

gani7787 17-Jan-12 5:44am

both are integer data type

Amir Mahfoozi 17-Jan-12 5:49am

so try this :
select * from tab1 where startsal between 10 and 89 and Endsal between 2010 and 8800

2 solutions

Solution 1

Try this

SQL

select * from tab1 where startsal between 1 and 89 and Endsal between 2010 and 8800

Posted 16-Jan-12 23:35pm

RDBurmon

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rockstar_ · Accepted Answer · 2012-01-16T23:44:00

Solution 2

I have executed this querry and giving result...
this may help you..
Dont include single quotes for string values...

select Count(*) from sal where startsal between 10 and 80 and endsal between 20000 and 40000

Posted 16-Jan-12 23:44pm

Rockstar_

Updated 16-Jan-12 23:45pm

v2