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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the 2 sqlcodes that are returned?

1128


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1003


What is the difference between drop table and delete table?

1116


What is the function of logging in the db2 database?

1066


How to check last update on table in db2?

999


What is lock escalation in db2?

963


What is the role of data manager in the db2 database?

1050


How can we read records for specific member in CL? AND rpg?

643


What is innodb buffer pool?

974


Where do you specify them?

1161


What is a storage group (stogroup)?

1189


How do you find the maximum value in a column in db2?

1052


Is the primary key a clustered index?

1077


How and when does the db2 enforces the unique key?

1028


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1048