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
- 1 Answers
- 3242 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
What is shared buffer in postgres?
Provide an explanation about write ahead logging?
How many columns can a postgres table have?
How do I alter a table in postgresql?
What is difference between postgresql and mysql?
Which is better mysql or postgresql?
What is stack builder?
What is pg pool?
What is the use of geoserver?
How do I connect to postgresql access?
Is postgresql cloud based?
Does postgres cache queries?
How do I add one column in postgresql?
What is the index key?
What is instance in postgresql?
