select sname,max(marks) from student group by sname;

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
10009 Views
I also Faced
E-Mail Answers

Answer Posted / kotesh

select sname,max(marks) from student group by sname;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a sql select statement?

1011

what is datawarehouse? : Sql dba

971

Is full outer join same as cross join?

935

How can check sql version from command line?

1033

Are stored procedures faster than dynamic sql?

998

how to convert dates to character strings? : Sql dba

1109

What are different joins used in sql?

1029

What are aggregate functions in sql?

1114

what is auto increment? : Sql dba

979

what is the difference between nested subquery and correlated subquery?

1004

What is your daily office routine?

2231

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1023

What is db journal file?

995

Is natural join same as inner join?

886

how to use in conditions? : Sql dba

983