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
It can be easily defined as: The database must not have any unmatched foreign key values. The term "unmatched foreign key value" means a foreign key value for which there doe

Question: This question refers to the database schema. a) Express the following queries in SQL: (i) Write the SQL code that will create the table Company. Your answer sh

Explain Network Model in DBMS? Network Model - It was formalised within the late year of 1960s through the Database Task Group of the Conference on Data System Language (DBTG

intent locking

What is the use of a slotted-page structure and what is the information are there in the header? The slotted-page structure is used for organizing records within a one block.

Define raid? Briefly explain it? A range of disk organization methods, collectively called redundant arrays of independent disks (RAID) o   Improvement of reliability throug

What is meant by software and hardware RAID systems? RAID can be executed with no change at the hardware level, using only software modification. Such RAID implementations are

Explain the ACID properties of a transaction Ans: ACID properties are a significant concept for databases. The ACID stands for Atomicity, Consistency, Isolation, and Durability

Which two files are used during operation of the DBMS? Data dictionary and transaction log are two files used during operation of the DBMS.

Example - ALTER TABLE emp MODIFY (empno NUMBER (7));