name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

What is number function in sql?

0 Answers  

---

How do you assign Construct the where clause without concatenating Field,value pairs?

1 Answers   Microsoft,

---

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,

---

what is the difference between truncate and delete statement? : Transact sql

0 Answers  

---

How does sql developer connect to oracle database?

0 Answers  

---

Why do we use sql constraints?

0 Answers  

---

What is the use of stored procedures?

0 Answers  

---

What is indexes?

0 Answers  

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

what is a table in a database ? : Sql dba

0 Answers  

---