Answer / pravati

In two ways we can use count
1. SELECT COUNT(*) FROM table name.
2.SELECT COUNT(DISTINCT *) from table name.

Answer / krishna

select count(1) from table name

Explain the truncate command? : SQL Server Architecture

1 Answers  

---

What are differences in between sql server 2012 and sql server 2016?

1 Answers  

---

What is raiseerror? What is raiseerror?

1 Answers  

---

What is data file in computer?

1 Answers  

---

How to provide values to user defined function parameters?

1 Answers  

---

What is the use of “join” in sql server?

1 Answers  

---

What number aggregate functions are accessible there in sql?

1 Answers  

---

how can ur insert the emp table

3 Answers   Wipro,

---

How you can change a cross join into an inner join?

1 Answers  

---

Can you tell me about the concept of ER diagrams?

1 Answers  

---

Explain about Normalization?

1 Answers   Infosys,

---

What are the different types of replication you can set up in sql server?

1 Answers  

---