Advanced Search

Return to Snippet

Revision: 71311
at February 17, 2017 05:25 by bbrumm
Initial Code 
--COUNT

SELECT COUNT(*)
FROM student;


SELECT COUNT(DISTINCT gender)
FROM student;



SELECT DISTINCT COUNT(gender)
FROM student;


SELECT gender, count(*)
FROM student
GROUP BY gender;



SELECT COUNT(*)
FROM student
WHERE fees_paid >= 100;




SELECT gender, count(*)
FROM student
WHERE fees_paid >= 100
GROUP BY gender;
Initial URL 
http://www.databasestar.com/oracle-count/
Initial Description 
A few examples of the COUNT function.
Initial Title 
Oracle COUNT Function
Initial Tags 
sql, Oracle
Initial Language 
SQL