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
write an SQL statement to create the database in MYSQL server

What is object identity? An object retains its identity even if some or all the values of variables or explanations of methods change overtime.

Let us now talk about the relational operations: SELECT The select operation is used to select few specific record from the database based on different criteria, This is a un

What is an index? An index is a structure that helps to place desired records of a relation quickly, without probing all records.

What do you mean through integrity constraints? Integrity Constraints -An integrity constraint is a condition specified on a database schema and restricts the data in which

How the time stamps are implemented Use the value of the system clock as the time stamp. That is a transaction's time stamp is equivalent to the value of the clock when the tra

Question (a) Differentiate between the following terms: (i) Distributed Database v/s Distributed Database management System (ii) Homogeneous Distributed Database v/s Hete

DROP TABLE Command: When an existing object is not needed for further use, it is always better to eliminate it from the database. To remove the existing object from the databas

1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development

You have a friend that runs a motor bike club that holds racing events at various venues on weekends, on a monthly basis. Some venues are private race tracks and some are dirt trac