At present for reporting I use following types of query: select crm.*, crm_cnt.cnt from crm, (select count(*) as cnt from crm) crm_cnt; Here count query is used to find the total number of records. Same FROM clause is copied in both the part of the query. Is there any other good alternative way to get this similar value?
- [PERFORM] how to get the total number of records in repor... AI Rumman
- Re: [PERFORM] how to get the total number of records... Josh Kupershmidt
- Re: [PERFORM] how to get the total number of rec... AI Rumman
- Re: [PERFORM] how to get the total number of... Greg Spiegelberg
- Re: [PERFORM] how to get the total number of records... Merlin Moncure
- Re: [PERFORM] how to get the total number of rec... Robert Haas
- Re: [PERFORM] how to get the total number of... Merlin Moncure
- Re: [PERFORM] how to get the total number of... AI Rumman
- Re: [PERFORM] how to get the total numbe... Merlin Moncure