COUNT « Aggregate Functions « Oracle PL / SQL

Home
Oracle PL / SQL
1.Aggregate Functions
2.Analytical Functions
3.Char Functions
4.Constraints
5.Conversion Functions
6.Cursor
7.Data Type
8.Date Timezone
9.Hierarchical Query
10.Index
11.Insert Delete Update
12.Large Objects
13.Numeric Math Functions
14.Object Oriented Database
15.PL SQL
16.Regular Expressions
17.Report Column Page
18.Result Set
19.Select Query
20.Sequence
21.SQL Plus
22.Stored Procedure Function
23.Subquery
24.System Packages
25.System Tables Views
26.Table
27.Table Joins
28.Trigger
29.User Previliege
30.View
31.XML
Oracle PL / SQL » Aggregate Functions » COUNT 
1.COUNT(column) and COUNT(*): count the number of rows passed into the function.
2.Syntax: COUNT([DISTINCT]|[ALL] )
3.Using GROUP BY would tell us how many cars from each vendor we have on the lot:
4.Find out which maker has a null value car with count()
5.-Using the COUNT function in Having clause
6.Example using the COUNT function with group by clause
7.Count with group by: count for a group value
8.Get the number of rows in each city group using the COUNT() function
9.count null
10.Column alias name for count function
11.Count(*) - count(column_Name)
12.count distinct column value
13.count(1)
14.count(distinct state)
15.Count(*) and column renaming
16.Count() with where clause
17.Count date field value, and calculation
18.Count department and calculate average salary
19.Count employee in a department after grouping by department id
20.Count employee, group by department id and job title
21.count(*) - count(onhand)
22.count(*) vs count(column name)
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.