Write query to get the max and min salary of job_id 101

asked Mar 28, 2022 8.5k views

8 votes

7.0k points

Please log in or register to add a comment.

11 votes

Answer:

SELECT MAX(salary), MIN(salary) FROM salaries WHERE job_id=101

Step-by-step explanation:

Assumptions were made on the column and table names...

Mukul Goel answered Apr 2, 2022

6.8k points

Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

7.8m questions

10.4m answers