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 a relationship and what are they?

568

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

6049

---

What does the sign mean in sql?

497

---

what is the functionality of the function htmlentities? : Sql dba

510

---

What is database sql?

531

---

---

How do I create a sql script?

527

---

How to combine two stored procedures in sql?

580

---

How do I truncate a sql log file?

525

---

What do you think about pl/sql?

522

---

Explain unique key in sql.

552

---

What is sql integrity?

570

---

What is a record in a database?

551

---

How do you optimize a query?

524

---

What is the difference between left outer join and left join?

501

---

what is uncommittable transactions? : Transact sql

554

---