It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes SQL count statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL count statement" Watch "SQL count statement" New topic

SQL count statement

Henry ostley

Joined: Mar 04, 2012
Posts: 4
Is it possible in a count statement to return the value that is being counted as well as the actual number of times it appears?
So for instance:
Oxford 4
Cambridge 7
LSE 14
Martin Vajsar

Joined: Aug 22, 2010
Posts: 3728

Something along the lines of might fit your need, if I understood it correctly.

An SQL tutorial might come in handy.
I agree. Here's the link:
subject: SQL count statement
It's not a secret anymore!