Answer Posted / apoorva garg

cityno cityname mails
1 BANGALORE 8KM
2 HSR LAYOUT 20KM
3 MEJISTIC 30KM
4 JAYADEVA 55KM
5 ITPL 80KM
6 HEBBAL 115KM

create table city(name varchar2(10), miles number);
insert into city values('bangalore',8)
insert into city values('hsr',20)
insert into city values('majestic',30)
insert into city values('jayadeva',55)
insert into city values('itpl',80)
insert into city values('hebbal',115)

DISTANCE NO.OFCITY
0-50KM 3
51-100KM 2
101-150KM 4


select * from city


select count(miles),miles
from
(select name,
CASE
WHEN (miles>=0 and miles <=50) THEN '0-50KM '
WHEN (miles>=51 and miles <=100) THEN '51-100KM '
WHEN (miles>=101 and miles <=150) THEN '101-151KM '
END miles
from city)

group by miles

Explain autonomous transaction.

1148

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1166

---

How do you use collections in procedure to return the resultset?

2229

---

What are the sql commands?

1138

---

What is the use of procedures?

964

---

What is sqlite used for?

980

---

What is sql query optimization?

1089

---

What is embedded sql with example?

1018

---

How many types of functions are there in sql?

932

---

How do I make my sql query run faster?

918

---

what is a constraint? Tell me about its various levels. : Sql dba

969

---

What is the difference between having and a where in sql?

1080

---

How to select 10 records from a table?

1141

---

Is sql a microsoft product?

935

---

what is a trigger in mysql? Define different types of trigger. : Sql dba

1052

---