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
Answers were Sorted based on User's Feedback
Answer / kart
select sname,max(mark) from xtable group by sname;
che 56
mat 40
phy 33
Is This Answer Correct ? | 14 Yes | 2 No |
Answer / giri babu
select sname,max(smarks)
from t1
group by sname
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kotesh
select sname,max(marks) from student group by sname;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sumit
select subject,max(marks) from t1 group by subject;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / dharmendra
select subject,max(marks) from table_name
group by subject
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kotesh
select subname,max(marks) from t1 groupby subname
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / satishilluri
select max(math)max(phy),max(che) from t1
Is This Answer Correct ? | 9 Yes | 12 No |
Answer / naresh
select subid,max(math),max(phy),max(che) from tablet1
group by subid
Is This Answer Correct ? | 0 Yes | 3 No |
What is the example of procedure?
what is auto increment? : Sql dba
Why are sql stored procedures used?
I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible
Can pl sql procedure have a return statement?
What are sql functions? Describe in brief different types of sql functions?
How do you pronounce sql?
Which normal form is best?
What does select top 1 do in sql?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is snowflake sql?
What is row_number () in sql?