How would you find out the total number of rows in a DB2 table?

Use SELECT COUNT(*) … in db2 query

 How do you eliminate duplicate values in DB2 SELECT ?

Use SELECT DISTINCT … in db2 query

 How do you select a row using indexes in DB2?

Specify the indexed columns in the WHERE clause of db2 query.

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

Use SELECT MAX(…) .. in db2 query

Advertisements