What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 26982 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 is ms sql server index?
What is the need for group functions in sql?
Tell me what is use of except clause? How it differs from not in clause?
What is the maximum size of a row in sql server?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
What are Spatial data types in SQL Server 2008
What do you mean by tablesample?
How to change the ownership of a schema in ms sql server?
What are date and time data types in ms sql server?
Explain the various types of concurrency problem?
List out some of the requirements to set up a sql server failover cluster?
How to create and drop temp table in sql server?
Explain how does the report manager work in ssrs?
What is indexed view?
