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...


How do you define a correlated name?



How do you define a correlated name?..

Answer / s

Correlation name is defined in the FROM clause as a short
name for the table in the query

SELECT * FROM DSND810.EMP X
WHERE X.EMP = '0010'

X is the correlation name for DSND810.EMP

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More DB2 Interview Questions

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  


i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its

5 Answers   EDS,


how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,


What are host variables in db2?

0 Answers  


How connect db2 database to datastage?

0 Answers  


Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  


What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  


What happens in bind step in a db2 program?

0 Answers  


What is node in db2?

0 Answers  


how 2 resolve the -311 sqlcode

1 Answers  


Are views updatable ?

4 Answers  


What is clone table?

0 Answers  


Categories