Allen and roth gazebo warranty
Bfd cam dyno
Budget wheelchair van rental
Message-ID: [email protected]gham.ac.uk> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart ... If the tables (or at least a key column) are of the same type just make the union first and then count. select count(*) from (select tab1key as key from schema.tab1 union all select tab2key as key from schema.tab2) Or take your satement and put another sum () around it. SELECT customer_name, count(*) cnt from dtb_customer group by customer_name this will give you the count per customer_name to accomplish your goal...either wrap the sql like this... select * from (SELECT customer_name, count(*) cnt from dtb_customer group by customer_name) where cnt > 1 or get the same exact effect with the HAVING CLAUSE... This results in a table that looks like this: Step 4: We are on the right path but we are not quite there yet. Since the whole point of this table is to summarize this data into a more usable and presentable format, we want to add a summarization or aggregation function to the CASE statement columns in order to give our viewers the most summarized view into this data as possible.