pringlehannah3715 pringlehannah3715
  • 14-09-2019
  • Computers and Technology
contestada

list all columns of the resource table with a rate between $10 and $15 including the end points 10 and 15. Sort the result by rate.

Respuesta :

wein7145 wein7145
  • 14-09-2019

Answer:

select * from resources

where rate between 10 and 15

order by rate (ASC|DESC)

Explanation:

On Chegg + SQL textbook

(Here we are using * keyword to fetch all the records from resource table and between operator is used to fetch values between two vaues(values included).

Order By clause is used to sort the values and ASC is used with order by clause to sort in ascending order and DESC is used to sort in Descending Order.

By default if we do not specify anything then it will take ASC.

Answer Link

Otras preguntas

So I’m doing a PowerPoint of how social media changed my life any ideas what I should right down and what kind of topics should I put in 7 slides
Is the relationship shown by the data linear? How can you tell if it is or is not? If so, model the data with an equation.
How many slaves were transported over the middle passage
Are Jerry’s statements correct?
Which four goals were included in La Follette’s plan? select 4 options A. reform the tax system B. eliminate monopolies and trusts C. reform elections D. impro
Which feature of menu option of word processing program can you make images
how did the Phoenician glass trade impact the Mediterranean region? 10 POINTS
Where are building evacuation plans found? - at the main entrance Or - next to exit stairways
If I clock out at 2:38 and I have 30 minutes what time do I get in
In 4/4 time two eighth notes are equal to