select subject,max(marks) from table

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 / dharmendra

8 Answers
10237 Views
I also Faced
E-Mail Answers

Answer Posted / dharmendra

select subject,max(marks) from table_name
group by subject

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a table partition?

1131

How do I quit sql?

957

How can we solve sql error: ora-00904: invalid identifier?

1246

What is pl/sql language case sensitive?

1125

Can we connect to postgresql using sql developer?

1003

What are transaction and its controls?

1040

Can a composite key be null?

978

What trigger means?

977

What are the types of queries in sql?

1086

What are all different types of collation sensitivity?

1035

Explain the uses of a database trigger?

1043

What is asqueryable?

969

What is pivot in sql?

915

How delete all data from all tables in sql?

946

What are pl/sql cursors?

1049