How To Draw A Bargraph With The Data I Have Mentioned>

Question

1.00/5 (2 votes)

See more:

SQL

server

col1 col2 col3
3 4 5
5 5 6
i want average of each column to be displayed in a bargraph

Posted 20-Nov-15 6:49am

Member 8499677

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2015-11-20T08:38:00

Solution 1

You can't, not really - SQL is a data storage and retrieval system, and graphing is a presentation layer function. SQL can't talk directly to your users, and has no idea what kind of system the user is using: it could be web based via a browser, or direct via a command line application, or Winforms, or WPF, or ... SQL doesn't know, so it can't provide appropriate graphics.

Do this in your presentation software - it's relatively easy in most of them!

Posted 20-Nov-15 8:38am

OriginalGriff

Comments

Member 8499677 24-Nov-15 0:10am

thank you for your answer. But actually i want to find average of values in each column and then i want to store average values in rows. how to do it?
something like
col1 col2 col3
3 4 5
5 5 6

average of col1 is 4
average of col2 is 4.5
average of col3 is 5.5

now i want the average values to be stored in rows
avg1 4
avg2 4.5
avg3 5.5