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

Mapping, external and internal mapping with examples external and internal mapping with examples

Need for multiple access paths, Need for Multiple Access Paths In pract... Need for Multiple Access Paths In practice, most of the online information systems need the support of multi-key files. For example, consider a banking database application hav

ER Modeling, explain ER Modeling? explain ER Modeling?

What are stored and derived attributes, What are stored and derived attribu... What are stored and derived attributes? Stored attributes: The attributes keeps in a data base are known as stored attributes. Derived attributes: The attributes that are de

Database Models, Benefits and Limitations od Data Models? Benefits and Limitations od Data Models?

Explain the exists and unique functions of sql, Explain the EXISTS and UNIQ... Explain the EXISTS and UNIQUE functions of SQL. Give an example for each? EXISTS: The EXISTS function takes one parameter that is a SQL statement. If any records exist which

Sorting field groups we cannot use more than one key field, While sorting f... While sorting field groups we cannot use more than one key field False.

Many-to-many relationship, Many-to-many : Entities in A and B are related w... Many-to-many : Entities in A and B are related with any number of entities from each other. Example: Taught_by Relationship among course and faculty. One faculty member ca

Create table and insert data manufacturer-dbms, Create a table according to... Create a table according to given data:  AmbulanceDriver(Driver_Number#, Name, Address, Birth_Date) AmbulanceDriverTeam(Team_Number#, Driver_Number#, Join_Date, Lea

Differance between internal and external schema, Differance between interna... Differance between internal and external schema? Internal and external schema: Internal Schema • Describes the physical storage structure • Uses a physical data model External