Answer Posted / senthil

hi,
if mails field is numeric above query is correct but mails filed is varchar that is contain 'km' so test my query....
Ex:
select RANGE distance,count(range) no_of_city
from
(SELECT citiname,mails,
CASE WHEN to_number(substr(mails,0,(instr(mails,'k')-1))) BETWEEN 0 AND 50 THEN '0-50'
WHEN to_number(substr(mails,0,(instr(mails,'k')-1))) BETWEEN 51 AND 100 THEN '51-100'
ELSE '101-150'
END RANGE
FROM test1) group by range

explain the difference between bool, tinyint and bit. : Sql dba

1063

---

What is an escape character in sql?

1072

---

what are the performance and scalability characteristics of mysql? : Sql dba

1034

---

What does partition by mean in sql?

1030

---

How do I view tables in mysql?

1027

---

What is the maximum number of columns in sql table?

1228

---

What is foreign key and example?

982

---

How much does sqlite cost?

1094

---

Does access use sql?

1101

---

How many joins can you have in sql?

988

---

Can %notfound return null after a fetch?

1101

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4060

---

Can we rollback delete command?

1038

---

Do we need commit after truncate?

1136

---

define data blocks ? : Sql dba

1046

---