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 are the set operators in sql?

1073

---

How do I turn a list into a table?

963

---

What does subquery mean in sql?

1056

---

Define concurrency control. : Transact sql

1192

---

How many aggregate functions are available there in sql?

984

---

What are the popular database management systems in the it industry?

1000

---

Is crud a cuss word?

1036

---

What are the two types of periodical indexes?

940

---

how to return query output in html format? : Sql dba

1074

---

how to drop an existing view in mysql? : Sql dba

1061

---

How can you know that statistics should be updated?

1079

---

What are different methods to trace the pl/sql code?

1120

---

What are % type and % rowtype?

1030

---

What is rtm stands for?

1100

---

Can we alter stored procedure?

989

---