Having clause-data manipulation language, Database Management System

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







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
Related Questions

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

what is cascading? what is rollback cascading? please explain in detail

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

WHAT IS DSS? WRITE ITS REQUIREMENTS.

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. The average seek time is the average of the seek times, calculated over a sequence of random requests.

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 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