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 a constraint? Tell me about its various levels. : Sql dba

557

---

What are user defined functions?

575

---

How do I partition in sql?

534

---

What jobs use sql?

523

---

How to select unique records from a table?

565

---

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

510

---

how to calculate expressions with sql statements? : Sql dba

524

---

Explain what is table in a database?

570

---

What are the ddl commands?

530

---

What are different types of queries in sql?

517

---

Which type of cursor is used to execute the dml statement?

525

---

How does postgresql compare to mysql?

573

---

what is collation? : Sql dba

606

---

what are sequences

1086

---

what is transaction? : Sql dba

528

---