Posted By

bbrumm on 02/17/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 02/17/17 05:25am

Statistics

Viewed 626 times

Favorited by 0 user(s)

Related snippets

Oracle COUNT Function

/ Published in: SQL

A few examples of the COUNT function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

--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;