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 :

tonb
tonb tonb
  • 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

What influence did the Declaration of Independence have on the rest of the world
Describe the tone of the first two paragraphs. How does souiefs word choice in the two paragraphs affect the tone?
A baseball card store prints a total of 15,363 cards on Tuesday and Wednesday. It printed 3,978 cards on Wednesday. How many cards did the store print from Tues
hin What number makes this equation true? ? + +72 = 95 00
“Serving in Florida”What is the main point that Ehrenreich is making in her narrative? Where is this point most clearly stated? How well has she supported this
Refer to A Wrinkle in Time for a complete version of this text. At the beginning of Chapter 4, the characters find themselves in a strange place as they tesser
Identify three types of business where location is less important.
. y = 3x - 2; domain: x ≥ 0
Write an essay that explains how the foreshadowing in "The Monkey's Paw" by W. W. Jacobs creates tension, suspense, or both. Your essay will have an introductio
Find the area of the triangle.