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
Answer / 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 |
How to create a PostgreSQL user?
Is postgres is free?
What is edb postgres?
How to call postgresql function in asp net?
Explain about Triggers?
Does postgres have clustered index?
What is connection limit in postgresql?
Can you have a composite foreign key?
Is postgresql relational?
What is the default database in postgresql?
Is postgresql a language?
What does postgresql do?