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

How do you use join?

953

---

how to do backup entire database? : Transact sql

1155

---

What is materialized view. What are different methods of refresh?

1398

---

Can you have more than one key in a database?

947

---

Differentiate between syntax and runtime errors.

1199

---

Is sql harder than python?

1114

---

What does where 1/2 mean in sql?

1095

---

How to create a menu in sqlplus or pl/sql?

1131

---

Explain the working of primary key?

1108

---

what is a tablespace? : Sql dba

1067

---

How to use boolean type in select statement?

1087

---

what are the features and advantages of object-oriented programming? : Sql dba

1027

---

What does := mean in pl sql?

1052

---

What are different clauses used in sql?

1126

---

how to install mysql? : Sql dba

1125

---