Answer Posted / js

SELECT R,COUNT(R) FROM
(
SELECT cityname,mail,
CASE WHEN SUBSTR(MAIL,1,INSTR(MAIL,'KM' )-1) BETWEEN 0 AND 50 THEN '0-50'
WHEN SUBSTR(MAIL,1,INSTR(MAIL,'KM' )-1) BETWEEN 51 AND 100 THEN '51-100'
ELSE '101-150' END R FROM CITY) GROUP BY R;

Can we rollback truncate?

1004

---

What is sql basics?

1046

---

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1144

---

How do I view a sql database?

1023

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1080

---

Is pl sql better than sql?

1042

---

Does sap use sql?

997

---

What is attribute indicator in pl sql?

1017

---

Why do we need databases?

1052

---

Is a foreign key always unique?

949

---

What is cost in sql execution plan?

990

---

how to check myisam tables for errors? : Sql dba

1324

---

What is the command used to fetch the first 5 characters of a string?

1212

---

How many postgresql users are there, worldwide?

1069

---

What's the difference between a primary key and a clustered index?

989

---