[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

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 example, we

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 rows