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 the syntax to add a record to a table?

577

---

Is sql a case sensitive language?

516

---

What is right join in sql?

555

---

What are the syntax and use of the coalesce function?

553

---

What is foreign key in sql with example?

515

---

---

what are rollup and cube in t-sql? : Transact sql

661

---

What are the subsets of sql?

551

---

how to check server status with 'mysqladmin'? : Sql dba

570

---

What is an inconsistent dependency?

583

---

What is the difference between joins?

536

---

Why do we use %rowtype & %type in plsql?

608

---

What is dml with example?

517

---

explain the delete statements in sql

583

---

What are the built in functions of sql?

567

---

how do you know the version of your mysql server? : Sql dba

506

---