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
- 3922 Views
- CMC, I also Faced
- E-Mail Answers
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 do you create a database in pgadmin 3?
What is logical replication in postgresql?
Is postgresql a relational database?
What is write ahead logging in postgresql?
How to open postgresql gui in ubuntu?
How to connect postgresql database using pgadmin 4?
What is connection limit in postgresql?
How do you add a column?
Does creating a foreign key create an index?
What is the difference between a primary key and a composite key?
What is a postgres server?
What is max pool size?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
