1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

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

What are the types of queries in sql?

518

what happens if null values are involved in expressions? : Sql dba

563

how to create a table index in mysql? : Sql dba

593

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

718

What does fetching a cursor do?

613




What are the types of keys?

510

How many types of triggers exist in pl/sql?

561

How is data stored on a disk?

538

explain advantages of innodb over myisam. : Sql dba

646

Why is normalization important?

536

What are the ddl commands?

533

Does truncate free space?

515

Describe sql comments?

559

What is a string data type in sql?

512

how would you get the current date in mysql? : Sql dba

537