0 votes
in Information Technology by (15 points)
Vidhi Sharma is using a table Employee. It has the following columns: Admno, Name, Agg, Stream
[ Column Agg contains Aggregate Marks ]
She wants to display highest Agg obtained in each Stream. She wrote the following statement:
SELECT Stream, MAX(Agg) FROM Employee;
But she did not get the desired result. Rewrite the above query with necessary changes to help her get
the desired output.

Please log in or register to answer this question.

No related questions found

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.