what is the difference between where clause and having clause? : Sql dba

0 Answers  

---

Is sql microsoft?

0 Answers  

---

What is query syntax?

0 Answers  

---

what is rollback? : Sql dba

0 Answers  

---

How can analyze query after generating explain plan ?

2 Answers   Thermotech,

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---

1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.

1 Answers   Polaris,

---

How to fetch alternate records from a table?

0 Answers  

---

Mention what is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

---

What is compound trigger?

0 Answers  

---

How do I write a cron which will run a sql query and mail the results to agroup?

0 Answers  

---

What is plpgsql language?

0 Answers  

---