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

db2 sql interview questions

Moderator: Moderator Group

Post Reply
User avatar
Krishna
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

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

Post by Krishna » Sun Mar 29, 2009 9:28 pm

How would you find out the total number of rows in a DB2 table?
Last edited by Krishna on Sat Apr 11, 2009 4:36 pm, edited 2 times in total.

User avatar
Krishna
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

Post by Krishna » Sun Mar 29, 2009 9:35 pm

Use SELECT COUNT(*) ... in db2 query

yugandharj
Member
Posts: 4
Joined: Thu Jan 23, 2014 6:20 pm

Find total no of records in table without using select count

Post by yugandharj » Tue Nov 04, 2014 6:32 pm

Hi All,
How Find total no of records in table without using select count(*)?

yugandharj
Member
Posts: 4
Joined: Thu Jan 23, 2014 6:20 pm

Post by yugandharj » Tue Nov 04, 2014 6:36 pm

Hi All,
How optimize query performance, what are the steps.

dishaclasses
Member
Posts: 2
Joined: Tue Feb 03, 2015 5:12 pm
Location: India
Contact:

Post by dishaclasses » Tue Feb 03, 2015 6:40 pm

Select COUNT(*); in db2 query :D


Top Engineering Classes in Delhi

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others