Answer Posted / shriram2012

SQL> select * from quest;

Cityno cityname mails
---------- -------------------- ----------
1 bangalore 8km
2 hsr layout 20km
3 mejistic 30km
4 jayadeva 55km
5 itpl 80km
6 hebbal 115km

6 rows selected.

SQL> with data as (
2 select level as lvl,lag(level,1,0) over(order by level) as pre_lvl
3 from dual
4 where mod(level,50) = 0
5 connect by level <=150)
6 select count(cityno),pre_lvl||'-'||lvl
7 from quest
8 ,data
9 where to_number(replace(mails,'KM',0))/10 between pre_lvl and lvl
10 group by lvl,pre_lvl;

What is insert command in sql?

1192

---

what is text? : Sql dba

1120

---

Do we need commit after truncate?

1136

---

Where is sql database stored?

1039

---

When is the explicit cursor used ?

1091

---

What is pl/sql table? Why it is used?

1080

---

How do I pipe the output of one isql to another?

1058

---

How do you change a value in sql?

1068

---

What are all ddl commands?

1131

---

how is exception handling handled in mysql? : Sql dba

1132

---

Where is all the data on the internet stored?

1060

---

How do I create a memory optimized filegroup?

1012

---

what are different types of collation sensitivity? : Sql dba

1121

---

What do you understand by exception handling in pl/sql?

1089

---

What is the maximum rows in csv?

978

---