Differences

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

--- oracle:sql:count [2021/08/08 16:09] – created peter
+++ oracle:sql:count [2021/08/08 18:07] (current) – peter
@@ Line 1: / Line 1: @@
 ====== Oracle - SQL - Count ======
-A query can be wrapped in another SELECT:
+[[Oracle:SQL:Count:Count|Count]]
-<code sql>
+[[Oracle:SQL:Count:Count Distinct|Count Distinct]]
-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>