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

What has stored procedures in sql and how we can use it?

569

---

What's the difference between a primary key and a clustered index?

517

---

What is cost in sql execution plan?

490

---

Explain the update statement in sql

562

---

Explain the structure of pl/sql in brief.

621

---

---

What are different functions in sql?

519

---

What is sql and its types?

625

---

Can we call a function containing dml statements in a select query?

546

---

What are functions in sql?

511

---

what is foreign key? : Sql dba

589

---

What is the difference between left outer join and left join?

516

---

What are the sql versions?

522

---

What are the types of operators available in sql?

554

---

What is normalization sql?

513

---

how to concatenate two character strings? : Sql dba

554

---