simzz786 simzz786

25-10-2020
Computers and Technology

contestada

Let's say a query would generate an important volume of results. What would you need
to add to the query in order to retrieve only the 10 first results.

Respuesta :

25-10-2020

Answer:

It depends on the type of database:

MySQL, Postgres: ... LIMIT 10

MS-SQL: SELECT TOP 10 ...

Oracle: WHERE ROWNUM<=10

Explanation:

There is no single answer because the syntax is different across database vendors.

Answer Link

Otras preguntas

Which of the following statements about attitudes is true? a. It isn’t possible to measure implicit or explicit attitudes. b. People’s explicit attitudes are a

Evaluate the expression for j=-1 6j=_____?

A parallel-plate capacitor with circular plates of radius R is being charged by a battery, which provides a constant current. At what radius inside and outside

Which Buddhist temple is found at Sanchi, India?

My Notes In an experiment to compare the tensile strengths of I = 6 different types of copper wire, J = 5 samples of each type were used. The between-samples an

The resistance, R of a wire varies directly as the length, l, and inversely as the diameter, d, squared. If R is 1.50ohms when l=2.0 m and d=1.5 mm, what is th

Read this excerpt from The Adventures of Robinson Crusoe: But how just has it been! and how should all men reflect that, when they compare their present condit

On January 1, Year 3, Boxwood, Inc. issues 1,000 shares of $1 par value common stock for $30 per share. Later that year, the company issues 1,000 shares of $10

On a compromised computer, you have found that a user without administrative privileges was able to perform a task limited to only administrative accounts. What

While at a conference dealing with issues related to aging, Eve is interested in learning about how sleep patterns change in late life. She will be best served