Interested to Buy Any Domain ? << Click Here >> for more details...
wht is d/f between union and joins ?
- 2 Answers
- 6417 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / amarnath reddy
use unions, merge the rows from morethan one table.
Ex: select accno.,accname from bank1;
union
select accno.,accname from bank2;
use Joins, merge the columns from morethan one table.
Ex: select i.accno., d.bcode from banktab i, dtlstab d
where i.bcode=d.bcode;
| Is This Answer Correct ? | 4 Yes | 1 No |
pls tell me abt the normalization five types....
What is lock contention?
What is a db2 package?
When do you use the IMAGECOPY?
Compare a subselect to a join?
Explain the function done by data manager?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
Where besides the DB2 catalog is database object information stored by DB2?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
How will fetch last 5 rows from table in db2
How do you insert a record with a nullable column?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
COBOL 
