Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3799 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
How to get current date in postgresql?
How do I add a column in postgresql?
List different datatypes of postgresql?
What is use of postgresql?
Where is psql data stored?
What is a schema in postgres?
What is the use of geoserver?
What is postgis and postgresql?
Who owns postgres database?
How to change postgresql root user password?
Does postgres have clustered index?
What command do you type to exit the postgresql console application?
What is the advantage of postgresql?
Does postgres automatically index primary key?
What is the default postgres database?
