Differences

This shows you the differences between two versions of the page.

--- oracle:sql:count:count [2021/08/08 18:07] – created peter
+++ oracle:sql:count:count [2021/08/08 18:07] (current) – peter
@@ Line 1: / Line 1: @@
 ====== Oracle - SQL - Count - Count ======
+A query can be wrapped in another SELECT:
+<code sql>
+select count(*)
+from
+(
+select count(SID) tot  -- add alias
+from Test
+where Date = '2012-12-10'
+group by SID
+)
+select count(*)
+from
+(Select COLUMNS
+ from SCHEMA.TABLE
+ where nvl(TRADING_BRANCH||TRADING_ACCOUNT, 'ZZZZ') = 'ZZZZ' and LEGACY_PARTNER_TYPE in ('DELIVERY', 'MND'))
+select column_name, count(column_name)
+from table
+group by column_name
+having count (column_name) > 1;
+</code>