Answer / raju

Having clause is applied only to the group by function
where as where clause is applued to each and every row in a
table

Answer / dhiman

Where clause is used to check for the condition- select rows
& restrict rows and where comes before having clause whereas
Having is clause that is created to utilize all the group
functions (sum,avg,min,max,count) and is used for select or
restrict a particular group.

Answer / anil sharma

Having clause ia used only with group by, and where used with any input type

Where are sql server usernames and passwords stored in the sql server?

0 Answers  

---

Do you know what is a trace frag? Where do we use it?

0 Answers  

---

What is the sql case statement used for?

0 Answers  

---

What is the difference between insensitive and scroll cursor?

0 Answers  

---

How will you make an attribute not process? : sql server analysis services, ssas

0 Answers  

---

---

What is self join in sql server joins?

0 Answers  

---

Whether the updations made to the views reflect the original records in the table

5 Answers   NIIT,

---

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

0 Answers  

---

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

---

What is BCNF? How is it better than 2NF & 3NF?

0 Answers   Essar,

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

What is the use of sign function?

0 Answers  

---