Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dineshkumar
Starting Member
1 Post |
 Posted - 2011-04-12 : 05:33:22
|
| hi iam dinesh ,iam having one problem that is iam having 30 lakhs numarical data in one column i have to fing some ranges in that data how can i findout.example:1000 numbers is there i have to find out between 10 to 40,50 to 78,90 to 112 etc how can find out with querydinesh |
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-04-12 : 05:49:35
|
| select * from yout_table_name where column_name between 10 and 40 or column_name between 50 and 78 or column_name between 90 and 112Raghu' S |
 |
|
|
|
|
|
sqlquery for finding range