priyankasoni05027 priyankasoni05027
  • 14-02-2021
  • Computers and Technology
contestada

write query to get the max and min salary of job_id 101​

Respuesta :

tonb
tonb tonb
  • 14-02-2021

Answer:

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

Explanation:

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

Answer Link

Otras preguntas

Remote users can connect to an organization’s network through this type of secure private connection.
Which one is it ASAP
A stone of mass m is thrown upward at a 30? angle to the horizontal. At the instant the stone reaches its highest point, why is the stone neither gaining nor lo
A pizza parlor offers 4 different pizza toppings. How many different kinds of 2-topping pizzas are available? 10 kinds 6 kinds 5 kinds 20 kinds
simplify the expression (-1-3i)(-6-i)
The nominal exchange rate is 30 thai bhat for one u.s. dollar. a sub sandwich combo deal in the u.s. costs $6 dollars in the u.s. and 120 bhat in thailand. the
Which statement best expresses an idea held by many Renaissance humanist philosophers? A. People should study wordly subjects as well as religious matters B
If a population of nitrogen fixing bacteria in an ecosystem was severely decreased, which is the most likely result
Based on the location of nitrogen (N) on the periodic table, how many additional electrons does a nitrogen atom need in its valence shell to satisfy the octet r
For the following geometric sequence find the explicit formula. {12, -6, 3, ...}