Answer / Bobindra

WHERE clause is used to filter records in a SELECT statement before the GROUP BY operation. HAVING clause is used to filter groups or aggregate values after the GROUP BY operation.

Can we create clustered index without primary key?

1 Answers  

---

Which is faster count (*) or count 1?

1 Answers  

---

What is an inner join sql?

1 Answers  

---

What is the use of desc in sql?

1 Answers  

---

What is dml and ddl?

1 Answers  

---

what is oltp (online transaction processing)? : Sql dba

1 Answers  

---

What is the difference between clustered and non-clustered index in sql?

1 Answers  

---

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

Which one is the Best approach to put code, among Triggers and Procedures? Explain?

1 Answers   Sierra Atlantica,

---

what is the difference between where clause and having clause? : Sql dba

1 Answers  

---

What is mutating table?

11 Answers   Saama Tech,

---

Can a table contain multiple foreign key’s?

1 Answers  

---