Forums Register Login

SQL count statement

+Pie Number of slices to send: Send
Hi,
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
Thanks
2
+Pie Number of slices to send: Send
Something along the lines of might fit your need, if I understood it correctly.

An SQL tutorial might come in handy.
I am Arthur, King of the Britons. And this is a tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 848 times.
Similar Threads
ArrayIndexOutOfBoundsException
Count of Records
How to count the execution time of my select statement?
missing expression error
jtable help
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 02:01:16.