Having clause

• This clause is used for producing conditions on grouped information.

Example: Find maximum salary and department number of those departments where maximum salary is more than Rs 20000/-.

SELECT DEPTNO, MAX(SAL) FROM EMP

GROUP BY DEPTNO HAVING MAX(SAL) > 20000;

 

 

Posted Date: 3/11/2013 1:08:58 AM | Location : United States

Ask an Expert

Related Discussions:- Having clause-data manipulation language, Assignment Help, Ask Question on Having clause-data manipulation language, Get Answer, Expert's Help, Having clause-data manipulation language Discussions

Write discussion on Having clause-data manipulation language
Your posts are moderated

Write your message here..

Related Questions

Example of transaction? , Example :; transfers transfer_amount from x's acc... Example :; transfers transfer_amount from x's account to y's account ; Supposes x&y both accounts exist TRANSACTION (x, y, transfer_amount) Start transaction IF X AND Y

File organisation and its types, File Organisation And Its Types  Just ... File Organisation And Its Types  Just as arrays, trees, lists and other data structures are used to execute data Organisation in main memory, a number of planning's are used to

Define object-relational systems, Define object-relational systems? Sy... Define object-relational systems? Systems that give object-oriented extensions to relational systems are known as object-relational systems.

Determine the advantage of object-orientation, Determine the advantage of o... Determine the advantage of object-orientation Finally, object-orientation has advantage of continuity throughout analysis, persistent representation and design implementation.

Normal forms, normal forms normal forms

Advantages of database systems, Problem 1. Describe the following a)... Problem 1. Describe the following a) Advantages of Database Systems b) Functions of a DBMS Explanation of part (a) and (b) 2. Explain the following concepts w

Increased overheads on update-data replication, Increased overheads on upda... Increased overheads on update : On the drawbacks side, it will need the system to ensure that all replicas of a relation are consistent. This shows that all the replicas of the rel

What are partial and natural key, What are partial, alternate,, artificial,... What are partial, alternate,, artificial, compound and natural key? Partial Key: It is a set of attributes that can uniquely recognize weak entities and that are related to s

Define a relation schema, A Relation Schema represented by R(A1, A2, ..... A Relation Schema represented by R(A1, A2, ..., An) is made up of the relation name the list of attributes and R Ai that it contains. A relation is described as a set of tuples

Order by clause-data manipulation language, Order by clause By usin... Order by clause By using this rows can be sorted It is used in the last portion of select statement By default it gets ascending order DESC: is used