Interested to Buy Any Domain ? << Click Here >> for more details...
Which one allows duplicate values Union or Union All ?
- 3 Answers
- 7525 Views
- I also Faced
- E-Mail Answers
Answer Posted / mahesh
union all allows duplicates
union doesnt allows duplicates
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is performance tuning db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is scrollable cursor in db2?
can all users have the privilage to use the sql statement select * (dml)?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is the information associated with sysibm.syslinks table?
What is multi row fetch in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Explain the contention situations caused by locks?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How does a cursor work?
What is node in db2?
Which component is responsible for db2 startup and shutdown?
What is the physical storage length of timestamp data type?
