Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 29316 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Having Clause is basically used only with the GROUP BY
function in a query. WHERE Clause is applied to each row
before they are part of the GROUP BY function in a query.
| Is This Answer Correct ? | 68 Yes | 4 No |
Answer / srinivas
HAVING CLAUSE is used for evaluating a condition with an
aggregate function, i.e., GROUP BY whereas WHERE CLAUSE is
used for general conditions.
| Is This Answer Correct ? | 35 Yes | 4 No |
Answer / manisha
Having clause is used to filter group while WHERE CLAUSE
is used to filter rows.
Having clause can have aggregate function but WHERE CLAUSE
cannot have aggregate function.
| Is This Answer Correct ? | 22 Yes | 9 No |
Answer / menagadev
The HAVING clause sets conditions on the GROUP BY clause
similar to the way WHERE interacts with SELECT. The WHERE
search condition is applied before the grouping operation
occurs; the HAVING search condition is applied after the
grouping operation occurs. The HAVING syntax is exactly
like the WHERE syntax, except HAVING can contain aggregate
functions.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / swati mandve
where clause is executed (for each row) first and
written before the group by statement..
having clause is strictly folllowed by groupby clause.to
filter the group.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / ravindran
1.WHERE clause can be used with SELECT,INSERT and UPADATE statements,where as HAVING clause can only be used with the SELECT statements.
2.WHERE filter after rows before aggregation(GROUPING),
where as,HAVING filters groups,after the aggregations are performed.
3.Aggregate functions cannot be used in the WHERE clause,unless it is in a sub query containing in a HAVING clause,where as,aggregate functions can be used in having clause.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / santosh pashupatimath
Having clause is used before aggregation and where clause is
used before aggregation
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / saisri
Where clause is used prior the grouping of data,
where as Having is used after grouping the result of the
data.
| Is This Answer Correct ? | 1 Yes | 5 No |
Answer / sudheer gowlikar
Having clause Specifies a search condition for a group or
an aggregate. HAVING can be used only with the SELECT
statement. HAVING is typically used in a GROUP BY clause.
When GROUP BY is not used, HAVING behaves like a WHERE
clause.
| Is This Answer Correct ? | 2 Yes | 9 No |
What is 1nf 2nf?
What is similarity and difference between truncate and delete in sql?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
When multiple after triggers are attached to sql table, how to control the order of execution?
What is a primary index?
How do I schedule a sql server profiler trace?
How to select Distinct columns from the table, table having 20 columns and i want all coulmns
Define self join in sql server joins?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
How do you test your database? : sql server database administration
What are functions
What is create statement?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
