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
Compute the closure (F+) for the following set of the functional dependencies defined on R(a,b,c,d), where F - {c→ a, ab → d, a → b, d → c}, i.e. what are all of the FDs implied b

Consider the subsequent relation   Professor (Pfcode, dept, head, time)   It is assumed that      (i) A professor can work in much more than one

Describe in brief about the Sequence Diagrams Sequence diagrams are interaction diagrams which emphasize time ordering of messages. In UML, it is shown as a table which shows

Cyber Transit Ltd keeps up-to-date information on the processing and current position of each dispatched item. Dispatched items are the main concern of the Cyber Transit product tr

Explain the term- signal-to-noise ratio A signal-to-noise ratio of 20 dB means that S/N = 100. As log2101 is around 6.658, the Shannon limit is around 19.975 kbps. The Nyquist

Explain Transaction manager and their work? Transaction Manager: Ensure the database remains in a constant (correct) state despite system failure, and in which concurrent trans

Determine object representation As a designer, we must choose properly that when to use primitive types in representing objects and when to combine groups of related objects,

Record based Logical Models: Use records as the key data representation components Examples: Relational Model: It shows data as well as relationship between data in the form


Use a Set operator to create a list of academics who have written or co-written less than 5 papers and also have greater than 3 interests. List their academic number in the output.