To get the maximun value

[runa12345]

Hi All,
I have data in this way:

Example:

Type, Value
A, 122
A, 136
A, 126
B, 111
B, 156
C, 187
C, 163
C, 145
my output should be :

Type, Value
A, 136
B, 156
C, 187

I have 10000 rows based on the type and max(value) i like to select rows. I am new to sql,can any help me in getting the query.

Thanks in advance

 

[BrianTyler]

select
type
,max(value)
from
tab1
group by
type;

This will give you the maximum value for each type.

Similarly, replace max by min, avg, sum to get the minimum, accumulated total and average for each type.

If you only want the types with a value higher than the average, add the phrase:

having max(value) > avg(value)