Answer Posted / prativa mishra

select range distance,count(range) no_of_city
from
(SELECT cityname,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 CITY1)
group by range

What is the non-clustered index in sql?

1064

---

Is left join same as join?

997

---

what is the difference between truncate and drop statements? : Sql dba

1126

---

Which language is used in sql?

1060

---

What are user defined functions?

1019

---

Is time a data type in sql?

910

---

How to create your own reports in sql developer?

1020

---

what are date and time data types? : Sql dba

984

---

What is difference between inner join and self join?

1085

---

What is the purpose of my sql?

952

---

What are string functions in sql?

1244

---

Mention what are the benefits of pl/sql packages?

1082

---

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

2263

---

How can use stored procedures in sql?

1140

---

How do I debug a stored procedure?

1114

---