Answer Posted / prasant kumar sahoo

Answer in Horizontal out put
select RANGE distance,count(range) no_of_city
from
(SELECT citiname,mails,
CASE WHEN MAILS BETWEEN 0 AND 50 THEN '0-50'
WHEN MAILS BETWEEN 51 AND 100 THEN '51-100'
ELSE '101-150'
END RANGE
FROM test1)
group by range;

Write a sql query to find the names of employees that begin with ‘a’?

1059

---

Are sql database names case sensitive?

1053

---

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1069

---

Explain two easy sql optimizations.

1076

---

Can pl sql procedure have a return statement?

1072

---

What are the possible values that can be stored in a boolean data field?

1043

---

What is the least restrictive isolation level? : Transact sql

1107

---

How do you modify a table in sql?

1166

---

What programs use sql?

1088

---

is it possible to pass an object or table to a procedure as an argument?

1179

---

What is an index in sql with example?

1022

---

Which is better join or subquery?

1192

---

What is the difference between left join and right join?

990

---

what are the differences among rownum, rank and dense_rank? : Sql dba

1087

---

Why do we create views in sql?

1220

---