Having clause-data manipulation language, Database Management System

Assignment Help:

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;

Related Discussions:- Having clause-data manipulation language

In which form of relational database developer refers, In which form of rel...

In which form of relational database developer refers to a record? In a tuple form of relational database developer refers to a record.

Database models, why are older data models are being replaced by new data m...

why are older data models are being replaced by new data models

What are the disadvantages of relational approach, What are the disadvantag...

What are the disadvantages of relational approach? Disadvantages of relational approach: • Substantial hardware and system software overhead • May not fit all business models •

Define transitive dependencies, What do you understand by transitive depend...

What do you understand by transitive dependencies? Define with an example any two problems that can take place in the database if transitive dependencies are available in the datab

Create role named roletable to allows a user to create table, Create role n...

Create role named role_table that allows a user to create tables. Using role_table allow users kripa and reena to create tables. CREATE ROLE role_table; GRANT CREATE ANY TABLE

Create table statements for original database, MySQL statements for extendi...

MySQL statements for extending the database to incorporate new facilities Deliverables for submission You must submit the following deliverables in the Assignment Dropbox in

Transaction, what are the states of transaction?

what are the states of transaction?

Describe the development process of object oriented methods, Describe the d...

Describe the development process of Object oriented methods Object oriented methods have roots which are strongly anchored back in the 60s, functional and structured methods we

Distinguish among a datareader class and a dataset class, Question (a) ...

Question (a) Concurrent access to data from a database is a normal part of application program usage. Describe three approaches to concurrency control (b) Distinguish among

Express types of information available in mysql, Express types of informati...

Express types of information available in MySQL? Information as regards the result of queries: This includes number of records affected by any SELECT or UPDATE or DELETE st

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages