Answer Posted / nans
Select FIELD1 From <TABLENAME> As Temp Group By FIELD1 Having
Count(*) >1;
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
What are the various data types available in db2?
What's The Percentage Free Space ?
How to run db2 command in windows?
What is a db2 cursor?
How do I import data from excel to db2?
What is runstats db2?
What is the picture clause of null indicator variable?
What are union and union all?
How would the varchar column remarks defined?
What is view db2?
How to find the number of rows in a db2 table?
What is bind package and plan in 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 .....
How to create backup table in db2?
What is the use of value function?