Answer / Kanchan Kumar

As mentioned in Q323810, COUNT(*) returns the total number of rows in a table. COUNT(column_name) will return the count of non-null values for that specific column.

Can we change the table name in sql?

1 Answers  

---

How to Declare Fixed Length String Value In PL SQL

1 Answers  

---

what is 'force view'?

3 Answers   Cap Gemini, SPIC,

---

Explain the difference between triggers and constraints?

1 Answers  

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1 Answers  

---

what is Difference between Having and Where clause?

5 Answers   IBM,

---

What is a self join ?

6 Answers   BirlaSoft,

---

What is sql profiler in oracle?

1 Answers  

---

Do view contain data?

6 Answers   Ramco,

---

what is the difference between char and varchar data types? : Sql dba

1 Answers  

---

What is the difference between UNIQUE KEY and UNIQUE INDEX?

3 Answers   TCS,

---

What is the importance of sqlcode and sqlerrm?

1 Answers  

---