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

What is query syntax?

978

---

Which is better trigger or stored procedure?

953

---

Explain the savepoint statement.

1102

---

what is isam? : Sql dba

1015

---

how can we optimize or increase the speed of a mysql select query? : Sql dba

949

---

How to move files from one directory to another in pl sql?

1196

---

What is delete command in sql?

1119

---

What is dense_rank in sql?

989

---

How many row comparison operators are used while working with a subquery?

1033

---

what are the difference between clustered and a non-clustered index? : Sql dba

1033

---

Why functions are used in sql?

996

---

What are triggers and its types?

1069

---

What are pl/sql cursor exceptions?

1110

---

Do ddl statements need commit?

974

---

How many unique keys can a table have?

1017

---