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

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

---

how can i view structure of table in sql server? tell me that query.

10 Answers  

---

What is user defined datatypes and when you should go for them?

0 Answers  

---

What is the stuff?

0 Answers  

---

How can sql server instances be hidden? : sql server security

0 Answers  

---

What is public role in sql server?

0 Answers  

---

Can you please explain the difference between function and stored procedure?

0 Answers  

---

Explain the types of indexes.

0 Answers   Accenture,

---

what is for foreign key ??

4 Answers   CarrizalSoft Technologies, Sabic,

---

What is a with(nolock)?

0 Answers  

---

What are exact numeric data types in ms sql server?

0 Answers  

---

When columns are added to existing tables, what do they initially contain?

0 Answers  

---