select (select studentname from student where stuid=a.studentid) as student

i have three table
1. student (stuid,name)
2. subject (subid,sname,studid)
3. marks (subid,studentid,marks)
i want the reslut of how as got max marks in each subject

sudentname,max(marks), name
abc,70,nikitha

Question Posted / somnath banerjee

1 Answers
4005 Views
CMC, I also Faced
E-Mail Answers

Answer Posted / somnath banerjee

select (select studentname from student where stuid=a.studentid) as studentname,marks,(select sname from subject where subid=a.subid) as name from (select subid,studentid,max(marks) from marks group by subid,studentid) a;

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 postgresql vs mysql?

908

What does postgresql mean?

890

What is function and stored procedure?

887

How do you query pgadmin?

870

What is toast in postgres?

978

What are the character types that are available in postgresql?

1451

What is postgres vacuum?

858

Is it postgre or postgres?

863

How do you run a query in pgadmin 3?

799

What is postgis extension?

893

What do you mean by catalog?

908

What is the advantage of postgresql?

896

Do indexes speed up queries?

996

What is blob in postgresql?

976

What is vacuuming in postgresql?

805