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 are joins in sql?

961

---

How do you write a subquery?

970

---

How is use pl and sql?

1004

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

1327

---

Why trigger is used in sql?

919

---

what are the properties and different types of sub-queries? : Sql dba

972

---

What is a join?

1024

---

Is vs as in pl sql?

935

---

What is the most important ddl statements in sql are?

949

---

Is primary key always clustered index?

949

---

How do you create an update query?

917

---

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

974

---

what are different types of keys in sql?

1067

---

How long will it take to learn pl sql?

892

---

What is sql query optimization?

1024

---