Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
2.1k views
in Computer by (79.0k points)

Consider the table 'Company'. XYZ wanted to display the highest salary of each department along with department names.

                     Table: Company

EMPID DEPARTMENT SALARY
E101 PERSONNEL 60,000
E102 PERSONNEL 65,000
E103 MARKETING 40,000
E104 PERSONNEL 62,004
E105 PERSONNEL 50,000
E105 MARKETING 35,000

XYZ entered the following SQL statement:

Select Department, MAX (Salary)

From Company

ORDER BY Department;

Identify error(s) in the above SQL statement.

Rewrite the correct SQL statement.

1 Answer

+1 vote
by (76.3k points)
selected by
 
Best answer

Select Department, MAX (Salary)

From Company

Group BY Department;

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.

Categories

...