How can you count the number of rows from a table tab?
Name the lockable units in DB2?
can we drop column from a table
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
How can we retrieve the total number of records in RPG & CLLE?
What is netezza database?
What is a DBRM, PLAN ?
How we create a tables in db2,what is the process/syntax to create a table with example plz?
What is runstats and reorg in db2?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
how can u retrieve the data from null values using applicaion program.
What is db2 command?