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
what is RDBMS? how it works? good example.

Describe Application programming interface? Application Programming Interface - Commercial SQL implementations take one of the two primary techniques for involving SQL in a p

Give the levels of data abstraction? There are three levels of Data Abstraction a) Physical level b) logical level c) view level

Update Anomaly : This anomaly is occurred due to data redundancy. Redundant information makes updates more complex since, for example, varying the name of the instructor of MCS-014

what are the main characteristics of database

How nulls are treated in comparison operator? Along with comparison (relational) operators, the null values are ignored as we cannot derive the relation along with the given op

1. Create the tables for the play-scheme database as specified in the TMA. 2. Enter the data as given in the spreadsheet. 3. Create queries to retrieve specified information

Describe the advantage of State chart Diagram A state chart represents a state machine, emphasizing flow of control from one state to other. A state machine is a behaviour whi

What are the kinds of Strings?  -A binary string in MySQL is one that MySQL treats as case sensitive in comparisons. -A non binary string in MySQL is one that MySQL does'nt

Why did SAP introduce the extended star schema? Explain why it is reported to be better than the traditional schema model?