File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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: 3733

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
jQuery in Action, 3rd edition