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

Explain data dictionary in short, Explain Data Dictionary in short? Explain Data Dictionary in short?

Central database schema, Show a centralised schema to support the operation... Show a centralised schema to support the operation of the system you have chosen, including in particular: the product catalogue; the outlets and respective stocks; customer record

Cascading, what is cascading? what is rollback cascading? please explain in... what is cascading? what is rollback cascading? please explain in detail

Create a query to produce single output-er model, This assignment concerns ... This assignment concerns the Research database. The database ER model is shown above, where attributes are omitted for clarity. The relational model for the database is: Departm

Define- relational algebra, Define- relational algebra. The relational ... Define- relational algebra. The relational algebra is a procedural query language. It having of a set of operations that take one or two relation as input and make a new relati

DSS, WHAT IS DSS? WRITE ITS REQUIREMENTS. WHAT IS DSS? WRITE ITS REQUIREMENTS.

Define single valued and multivalued attributes, Define single valued and m... Define single valued and multivalued attributes. Single valued attributes: attributes with a single value for a particular entity are known as single valued attributes. Mult

Define average seek time, Define average seek time. The average seek ti... Define average seek time. The average seek time is the average of the seek times, calculated over a sequence of random requests.

Define functional and multivalued dependencies, Define functional and multi... Define functional and multivalued dependencies.       Ans:  A functional dependency is a assets of the semantics of the attributes in a relation. The semantics point out how at

Explain the cascadeless schedule, Explain the Cascadeless Schedule A ca... Explain the Cascadeless Schedule A cascadeless schedule is one in which for every pair of transactions Ti and Tj like that Tj reads a data item before written by Ti, the commit