Answer / Mohd Ehtishamul Haque

Yes, the WHERE clause can be used before the GROUP BY clause to filter records before they are grouped. This allows you to perform a preliminary filtering of data and then group the filtered results.

How do you measure the performance of a stored procedure?

3 Answers   Infosys,

---

‘Order by’ is not allowed in a view how can you sort information from a view?

1 Answers  

---

How can you see what type of locks used?

1 Answers  

---

What do you mean by authentication modes in sql server?

1 Answers  

---

when you create a database how is it stored? : Sql server database administration

1 Answers  

---

When would you prefer to have a minimum number of indexes?

1 Answers  

---

What is sqlcmd?

1 Answers  

---

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1 Answers  

---

Explain the benefits of user-defined functions?

1 Answers  

---

how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers   TCS,

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

What stored by the msdb?

1 Answers  

---