Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 26, 2024

can you please show me how I can add DESC (depending order) in to my query please. it oracle 19c and it have to be

image text in transcribed

can you please show me how I can add DESC (depending order) in to my query please. it oracle 19c

and it have to be the top 5

SELECT products.product_id, products.product_name, order lines.quantity from products inner join order_lines on products.product_id = order_lines.product_id

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Azure SQL Database For Modern Developers Building Applications In The Microsoft Cloud

Authors: Davide Mauri, Silvano Coriani, Anna Hoffma, Sanjay Mishra, Jovan Popovic

1st Edition

1484263693, 978-1484263693

More Books

Students also viewed these Databases questions

Question

★★★★★

Jamison Auto Parts produces replacement parts for automobiles. Last year Jamison had EVA net income of $200,000, cost of capital of 10 percent, and EVA capital of $750,000. Determine the firm's...

Answered: 1 week ago

Question

★★★★★

2. Follow through with fair consequences.

Answered: 1 week ago

Question

★★★★★

What is a niche market?

Answered: 1 week ago

Question

★★★★★

Ten weeks of data on the Commodity Futures Index are 7.35, 7.40, 7.55, 7.56, 7.60, 7.52, 7.52, 7.70, 7.62, and 7.55. a. Compute the exponential smoothing values for = 0.2. b. Compute the exponential...

Answered: 1 week ago

Question

★★★★★

can you please show me how I can add DESC (depending order) in to my query please. it oracle 19c and it have to be the top 5 SELECT products.product_id, products.product_name, order lines.quantity...

Answered: 1 week ago

Question

★★★★★

Modified Makers manufactures a single product. The cost of producing and selling a single unit of this product at the company's normal activity level of 45,000 units per month is as follows: Direct...

Answered: 1 week ago

Question

★★★★★

Define and calculate the specific and relative humidity of atmospheric air

Answered: 1 week ago

Question

★★★★★

void *calloc(size_t nmemb, size_t size); According to the library documentation, The calloc function allocates memory for an array of nmemb elements of size each. The memory is set to zero. If nmemb...

Answered: 1 week ago

Question

★★★★★

Determine whether the sequence converges or diverges. How do you know if it converges or diverges? 1 + 5 + 25 + ... Answer: Converges because it has a sum and r > 1 .

Answered: 1 week ago

Question

★★★★★

If a function does not return anything, then what do you put for its return type? What type of value must the main function return?

Answered: 1 week ago

Question

★★★★★

The air pressure in a tire is 650 kPa. The internal surface area of the tire is 500 cm2. Determine the total force (in kN) applied by the air to the tire.

Answered: 1 week ago

Question

★★★★★

What are the Variable columns settings available in the Mining Models Tab?

Answered: 1 week ago

Question

★★★★★

What does the Mining Content Viewer in Visual Studio show in terms of Probabilities?

Answered: 1 week ago

Question

★★★★★

How are continuous variables normally handled in Decision Tree Algorithms?

Answered: 1 week ago

Previous Question Next Question