Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Explain the use of the WHERE clause.

Answers were Sorted based on User's Feedback



Explain the use of the WHERE clause...

Answer / tharanath.n

you can restrict the rows returned from query by using the
where clause,a where clause contain a condition that must
be met, and it directly follows the from clause. if the
condition is true, the row meeting the condition is returned

Is This Answer Correct ?    1 Yes 0 No

Explain the use of the WHERE clause...

Answer / s

The WHERE clause only retrieves the rows based on the
predicate coded in the SQL.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

How to solve S0C7 abend with out using DISPlay in 10 mins?

1 Answers   IBM,


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  


what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 Answers  


Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  


Which is faster delete or truncate?

0 Answers  


explain about index with examples

2 Answers   Syntel,


How could one combine a set of incremental image copies into a single copy?

1 Answers  


How to resolve -917 sql code in DB2?

3 Answers   Cap Gemini,


If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,


How does cobol compile db2 program?

0 Answers  


What is the difference between oracle and db2?

0 Answers  


Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,


Categories