This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
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

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
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: 3719

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!