asked 8.5k views
8 votes
Write query to get the max and min salary of job_id 101​

asked
User Bpeikes
by
8.4k points

1 Answer

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...

answered
User Mukul Goel
by
7.9k points