What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 26387 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / sararh
where clause uesd for the fiend out particulater records and
where clause u write after select statement.
Having clause used for combination of group by functions
with out group by function u can nit write the having caluse.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What specific conditions database should meet, before you can bulk copy data into it using bcp?
Scalability, Availability, Integration with internet, etc.)?
What is difference between order by and group by?
How to create database with physical files specified in ms sql server?
How to join two tables in a single query in ms sql server?
How to set the current database in ms sql server?
Where the sql logs gets stored?
Is resultset an interface?
What xml support does the sql server extend?
What is a non clustered primary key?
What are the steps to insert a table?
Explain relational data?
what stored procedure can you use to display the current processes? : Sql server administration
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
please differentiate between delete and truncate?
