what is the order of execution of where,having,group by in select stement

6 Answers   IBM, Tanla Solutions,

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

0 Answers  

---

Do you know query execution plan?

0 Answers  

---

What are the grouping functions?

0 Answers  

---

What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,

---

---

Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance

10 Answers   IBM,

---

What is a constant or literal in ms sql server?

0 Answers  

---

what is the difference between group and having give an example with query and sample output

7 Answers  

---

Tell me about Triggers?

3 Answers   Cap Gemini,

---

what are batch in sql server?

2 Answers   Satyam,

---

How many types of built in functions are there in sql server 2012?

0 Answers  

---

What is an example of a foreign key?

0 Answers  

---