GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Mainframe  >  DB2
Go To First  |  Previous Question  |  Next Question 
 DB2  |  Question 7 of 195    Print  
Explain the use of the WHERE clause. WHERE is used with a relational statement to isolate the object element or row.

  
Total Answers and Comments: 1 Last Update: September 30, 2005   
  
 Sponsored Links

 
 Best Rated Answer
—

No best answer available. Please pick the good answer available or submit your answer.
September 30, 2005 12:48:11   #1  
mahadev mahajan        
RE: Explain the use of the WHERE clause. WHERE is used...

 where clause is use to extrct only one record.it is used with GROUP BY CLAUSE.

     EG:-SELECT DNO FROM EMP WHERE SAL=4200

            GROUP BY DNO;

  DISCRIPTION:- where dno is (dept. no) emp is (employi table),

                        here we are retriving dept.no whose salary is 4200

                        & these dept no's are arrenged in acending order.


 
Is this answer useful? Yes | No

 Related Questions

Describe the elements of the SELECT query syntax. SELECT element FROM table WHERE conditional statement?
Explain the use of the WHERE clause. WHERE is used with a relational statement to isolate the object element or row.
Joins, unions and nested selects are used to retrieve data.  
Latest Answer : The two tables has to be linked.EXEC SQL SELECT A.EMP_ID, B.WAGE FROM Table1 A,  Table2 B WHERE A.EMP_ID = B.EMP_ID AND A.EMP_ID = ...
An outer join includes rows from tables when there are no matching values in the tables.  
Latest Answer : 3 types. Left outer Join----left table unmatched valyes are included.Right Outer Join---right table unmatched values are included.Full outer Join----Both table unmatched values are selected. ...
Group by controls the presentation of the rows, order by controls the presentation of the columns for the results of the SELECT statement.  
Latest Answer : Group By forms Groups (of course), but this means it also SORTS; but it will also retrieve a DISTINCT RECORD SETORDER BY Sorts by the columns included in the Statement, and does not retrieve DISTINCT Records.Neither determines the order of the columns ...
The explain statement provides information about the optimizer's choice of access path of the sql.  
Latest Answer : The EXPLAIN statement obtains information about access path selection for an explainable statement. A statement is explainable if it is a SELECT or INSERT statement, or the searched form of an UPDATE or DELETE statement.The information obtained is placed ...
An embedded sql statement may return a number of rows while the programming language can only access one row at a time. The programming device called a cursor controls the position of the row.  
Latest Answer : hi friends,             In DB2 actually we use CURSOR when there are more than one row to be fetched in a SELECT statement. ...
Denormalizing DB2 tables reduces the need for processing intensive relational joins and reduces the number of foreign keys.  
Latest Answer : In datawarehouse environment, mostly all the tables are semi- normalized ( ie it is fully normalized) to reduce no of joins . so de-normalization is having lot of advantages in datawarehouse . ...
To maintain the integrity of DB2 objects the DBD permits access to only on object at a time. Lock contention happens if several objects are required by contending application processes simultaneously. 
The two parameters used in the CREATE statement are the PCTFREE which specifies the percentage of free space for each page and FREEPAGE which indicates the number of pages to be loaded with data between 

 Sponsored Links

 
Related Articles

Breaking up XML into Relational Data

Breaking up XML into Relational Data While the preceding example shows how to construct an XML representation over relational data the example in this section illustrates how you can shred XML data back into relational data This reverse operation can be useful if your application works with relation
 

ODP.NET - OracleCommand Object

ODP NET More About the OracleCommand Object Till now we have seen OracleCommand working with OracleDataReader OracleCommand is not simply meant for OracleDataReader It has got a lot of functionality for itself Let us see few of the most commonly used features of OracleCommand in this section We will
 

Microsoft AJAX Library - Creating Object Members on the Fly

Creating Object Members on the Fly One major difference between OOP in C and ASP NET and OOP in JavaScript is that JavaScript allows creating object members on the fly" This is true for objects and classes that you create yourself and also for JavaScript s own objects and types as well He
 

Microsoft AJAX Library - Object-Oriented JavaScript

Object Oriented JavaScript Objects and classes are implemented differently in JavaScript than in languages such as C VB NET Java or C However when it comes to using them you ll feel on familiar ground You create objects using the new operator and you call their methods or access their fields using t
 

Concepts of Object-Oriented Programming

Object Oriented JavaScript In this chapter you ll learn about OOP Object Oriented Programming and how it relates to JavaScript As an ASP NET developer you probably have some experience working with objects and you may even be familiar with concepts such as inheritance However unless you re already a
 

Object-Oriented Client-Server Internet

Object Oriented Client Server Internet OCSI Environments as IT Infrastructure Client Server Basics Object Oriented Client Server Internet OCSI environments provide the IT infrastructure for supporting OCSI applications For our purposes infrastructure refers to operating systems networks middleware
 

JavaScript String Object

JavaScript String Object In this JavaScript tutorial you will learn about String Object purpose of string object in JavaScript purpose of string object indexof method lastIndexOf method and substring method along with syntax and example mosgoogle center Purpose of String Object in JavaScript The mai
 

JavaScript Date Object

JavaScript Date Object In this JavaScript tutorial you will learn about date object and methods of date object explained along with syntax and example mosgoogle center JavaScript Date Object Usage of Date Object Date object of Java Script is used to work with date and times General syntax for defini
 

What is Data Element

In some aspects of information technology, a data element is referred to as any named unit of data which may or may not consist of other data items. In many electronic record keeping applications, a data element is a combination of bytes or characters which refer to a separate item of information li
 

What are the limitations with switch statement?

Switch statement is a powerful statement used to handle many alternatives and provides good presentation for C program. But there are some limitations with switch statement which are given below: Logical operators cannot be used with switch statement. For instance case k>=20: is not allowe
 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape