What is the difference between where and having clauses, Database Management System

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







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
Related Questions
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? In the clustering file organization, records of several dissimilar relations are stored in the similar file.

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 Network Model.

does tables are called relations

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? Transaction processing is associated by producing detail, summary, or exception reports and recording a business activi

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 based on functional organisation

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