Oracle COUNT Function Examples

Posted 7 months ago     622      SQL oracle

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;


There are no comments yet.

You need to be logged in to post comments.

Welcome to Snippet Repo!

Discover, share and save useful code snippets.

Join our community over over 2,000 members! Currently a 48% acceptance rate. Apply for membership →