What is the difference between WHERE and HAVING clauses?.

Predicates in the WHERE clause applies to every tuple while the predicate in the HAVING clause applies to groups. 

Posted Date: 5/6/2013 3:43:39 AM | Location : United States

Ask an Expert

Related Discussions:- What is the difference between where and having clauses, Assignment Help, Ask Question on What is the difference between where and having clauses, Get Answer, Expert's Help, What is the difference between where and having clauses Discussions

Write discussion on What is the difference between where and having clauses
Your posts are moderated

Write your message here..

Related Questions

A table joined with itself is called, A table joined with itself is called ... A table joined with itself is called ? A table joined with itself is known as self join table. Normal 0 false false false EN-IN X-NONE X-NONE

What is known as clustering file organization, What is known as clustering ... What is known as clustering file organization? In the clustering file organization, records of several dissimilar relations are stored in the similar file.

Entities, Entities Let us first be aware of the question: What are e... Entities Let us first be aware of the question: What are entities? An entity is an object of concern used to show the things in the actual world, e.g., table, car, bo

Set concept is used in which type of modelling, SET concept is used in whic... SET concept is used in which type of modelling? SET concept is used in Network Model.

Tables, does tables are called relations does tables are called relations

How nulls are treated in comparison operator, How nulls are treated in comp... How nulls are treated in comparison operator? Along with comparison (relational) operators, the null values are ignored as we cannot derive the relation along with the given op

By which techniquestransaction processing is associated, By which technique... By which techniquesTransaction processing is associated? Transaction processing is associated by producing detail, summary, or exception reports and recording a business activi

Backward recovery (undo), Backward Recovery (UNDO): In this system the unco... Backward Recovery (UNDO): In this system the uncommitted changes made by a transaction to a database are undone.  Instead the system is reset to the last consistent state of databa

Management information system, management information system based on funct... management information system based on functional organisation

Draw entity relationship diagram, Draw entity relationship diagram for the ... Draw entity relationship diagram for the following scenario. A university has many departments whereas each department belongs to that particular uni. That uni has also many bui