select subname,max(marks) from t1 groupby subname

i have a table t1 a math 20
b phy 30
cchemisty 10
a math 40
b phy 23
c che 21
a math15
bphy 33
c che 56
write a quire to find out the max markr of each subject

Question Posted / kotesh

8 Answers
10494 Views
I also Faced
E-Mail Answers

Answer Posted / kotesh

select subname,max(marks) from t1 groupby subname

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is not null in sql?

1045

what is bdb (berkeleydb)? : Sql dba

1093

what is error ora-03113: end-of-file on communication channel?

1230

Is inner join same as self join?

1168

What is normalization sql?

1119

Can you select everything, but 1 or 2 fields, without writer's cramp?

1041

Explain architecture of sql server notification services?

1114

What is sqlite format?

1266

How do you run a query?

1051

What does count (*) mean in sql?

1657

When are we going to use truncate and delete?

1025

What is serial sql?

1043

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

1022

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

1013

What are the three pl sql block types?

1051