Re: [SQL] Distribution of results

2006-11-07 Thread Aaron Bono
On 11/1/06, Raghuraman K <[EMAIL PROTECTED]> wrote: Hi,      I have a table like this: create table(xyz char(10), answer number(4)).  There are a lot of rows in this table. I am looking at a query that will help me represent the distribution of data records based on the column answer. For example,

Re: [SQL] Distribution of results

2006-11-06 Thread imad
What else do you want to know about it? (keeping in mind the example you gave) Because, apparently this is just a matter of min and max. --Imad On 11/1/06, Raghuraman K <[EMAIL PROTECTED]> wrote: Hi,      I have a table like this: create table(xyz char(10), answer number(4)).  There are a lot of r

Re: [SQL] Distribution of results

2006-11-06 Thread Jorge Godoy
"Raghuraman K" <[EMAIL PROTECTED]> writes: > Hi, > >I have a table like this: create table(xyz char(10), answer number(4)). > There are a lot of rows in this table. I am looking at a query that will help > me represent the distribution of data records based on the column answer. For > exa

[SQL] Distribution of results

2006-11-06 Thread Raghuraman K
Hi,      I have a table like this: create table(xyz char(10), answer number(4)).  There are a lot of rows in this table. I am looking at a query that will help me represent the distribution of data records based on the column answer. For example, we may take that the highest entry for answer co