Write a Query to find the number of rows in a DB2 table.

1.	Write a Query to find the number of rows in a DB2 table.
Answer» Here, the INTERVIEWER might ask you to write down the query on a piece of paper or a GOOGLE doc or any other METHOD. Mostly, the interviewers do not ask you to write a query upon a pre-existing table. The query is: SELECT COUNT * FROM TABLENAME

Answer»

Here, the INTERVIEWER might ask you to write down the query on a piece of paper or a GOOGLE doc or any other METHOD. Mostly, the interviewers do not ask you to write a query upon a pre-existing table.

The query is:

SELECT COUNT * FROM TABLENAME

Discussion

No Comment Found

Related InterviewSolutions

How is INNER JOIN different from simply writing a JOIN?
What is DCLGEN in DB2?
As you know there are different sizes of locks. Can you tell how DB2 decides which lock size should be used?
What are the two levels of isolation and what is the major difference between the 2 levels?
How can you move a tablespace to a different DASD volume allocated to that tablespace if you have to use STOGROUP?
What is MAX in DB2? Is it possible to use MAX in a CHAR column?
What is a CURSOR and What is the use of it?
What is concurrency in terms of DB2?
What are UNION and UNION ALL in DB2? How do you differentiate between them?
What is the difference between the above two queries i.e. DELETE and DROP?

Write a Query to find the number of rows in a DB2 table.

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment