Answer Posted / azuan

example

explain analyze select br_loc,count(insp_id) from insp where
date_create between '2010-07-01 00:00:00' and '2010-07-31
23:59:59' group by br_loc

What is the difference between clustered and non-clustered index in sql?

953

---

How much does sql cost?

926

---

How many types of sql are there?

926

---

How do I view stored procedures?

912

---

discuss about myisam index statistics collection. : Sql dba

905

---

What is sqlerrm?

880

---

What is sql stand for?

944

---

What is pl sql collection?

917

---

How can get second highest salary in sql?

907

---

What is the difference between between and in condition operators?

939

---

Can we use distinct and group by together?

989

---

What are the types pl/sql code blocks?

1066

---

What are the two different parts of the pl/sql packages?

1023

---

What is rtm stands for?

1018

---

How can we find duplicate records in a table?

887

---