Hi Jinendra
Try this:
select cast(count(*) as bigint) from YourTable;
Regards
Etienne Stieger DW DBA, Technical Specialist Analytics and Information Management (AIM/EIW) Standard Bank
Attachments
Library
Quick Reference
Archives
Sample Index
2010 Indexes