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;

Are subqueries faster than joins?

1024

---

Which command is used to call a stored procedure?

1006

---

What are the types of records?

992

---

How to use sql*plus built-in timers?

1208

---

Explain unique key in sql.

1017

---

What is the use of sqlerrd 3?

944

---

What is the clause we need to add in function body to return variable?

1014

---

What does dml mean?

993

---

Are sql database names case sensitive?

1009

---

what is cross join? : Sql dba

1004

---

What is the purpose of the sql select top clause?

1118

---

Can you skip header records while loading? : aql loader

1057

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4027

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1151

---

what are the drivers in mysql? : Sql dba

1027

---