I have a problem of creating mysql that return a single value, calculated from values in a column.what kinds of function i think to use?
Jump to Post
What you are looking for is probably the group by clause. Group By consolidates the results for a unique value of one of the data fields. Below is an example of two tables joined and results given using group by.
To display the artists by name rather than ID numbers, …
All 2 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.