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
(A) For the relation; CarSales (RegNo, BuyerName, Address, SalesPerson, Make, Model, Commission) The following functional dependences hold, RegNo _ID à Make, Model Reg

Explain Stand Alone Query Language in details? Stand alone Query Language - The query language that can be used interactively is known as stand alone query language. It does no

A field-groups statement or an insert statement reverses storage space and transfers values. False.

What is a recursive relationship? Give an example not used in the text. A recursive relationship is a relationship among an entity and itself. For example, given the entity PER

Create Student DB and perform delete operation? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, co

What are the various properties of Relational tables? Relational tables have 6 properties: 1. Each row is unique. 2. Column values are of the same kind. 3. Values are

Load sample data into the database tables design and test queries to return the following information • All rows and columns for employees • All rows and columns for customers •

I want to fragment existing table using java code... help me..!!

What is DML (Data Manipulation Language)? This language that enable user to access or manipulate data as organised by appropriate data model. Procedural DML or Low level: DM

Birla Institute of Technology & Science, Pilani Work-Integrated Learning Programmes Division Second Semester 2012-2013 EC-1 Assignment 2 (7.5% of the grade) Course No. : SS ZG