Having clause with sub queries, Database Management System

Having Clause with sub queries: First we have to recollect the GROUP BYclause. The following query searches the minimum salary in every department.

SELECT DEPTNO, MIN (SAL)

FROM.EMP

GROUP BY DEPTNO;

Output:

DEPTNO

SAL

10

2975

20

3000

 

Posted Date: 3/11/2013 3:43:38 AM | Location : United States







Related Discussions:- Having clause with sub queries, Assignment Help, Ask Question on Having clause with sub queries, Get Answer, Expert's Help, Having clause with sub queries Discussions

Write discussion on Having clause with sub queries
Your posts are moderated
Related Questions
What is an index? An index is a structure that helps to place desired records of a relation quickly, without probing all records.

Normalize the following tables upto and including the 3NF. Submit a 1 page printout of only the final set of normalized tables in Data Architect. Just use Data Architect to do the

Table Handling  In RDBMS more than one table can be tackled at a time by using join operation. Join operation is a relational operation that causes 2 tables with a common domai

Economics: It is now usually accepted that it costs less to make a system of smaller computers with the equivalent power of a one large computer. It is more cost-effective to get s


1. Staff(staffID, firstName, lastName, availabilityID, experience, phone, mobile, email); 2. Availability(availabilityID, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday,

Distributed query and transaction processing a.  Construct a query around any one of the functional divisions you made in 4a such that if executed in the distributed design of 4

Draw an ER diagram that shows the organization of a simple student database. The database captures the information about letter grades obtained by university students who enrolled

The Third Normal Form (3NF) Even though, transforming a relation that is not in 2NF into a number of relations that are in 2NF take out many of the anomalies, it does not neces

Data Independence This brings us to our next topic: data independence. It is the property of the database which tries to make sure that if we make any change in any level of sc