Answer Posted / kavitha nedigunta

SELECT DISTANCE,COUNT(*) NO_OFCITY
from
(SELECT (CASE WHEN TO_NUMBER(RTRIM(MAILS,'KM')) BETWEEN 0
AND 50 THEN '0-50'
WHEN TO_NUMBER(RTRIM(MAILS,'KM')) BETWEEN 51 AND
100 THEN '51-100'
ELSE '101-150' END) DISTANCE
FROM TEST001) A
GROUP BY DISTANCE
order by to_number(replace(DISTANCE,'-',''))

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3947

---

What is a primary key called that is made up of more than one field?

1286

---

Can we create table in function?

907

---

how to use like conditions? : Sql dba

1040

---

What is the use of prepared statement?

954

---

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

3928

---

Can we write ddl statements in functions?

1054

---

What are analytical functions in sql?

972

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

928

---

What are the 3 modes of parameter?

1103

---

Why do we need cursor in pl sql?

1081

---

What is materialized view in sql?

875

---

How to execute a stored procedure?

1037

---

How to display Row Number with Records in Oracle SQL Plus?

993

---

what is a primary key? : Sql dba

984

---