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

Is a starfish an arthropod ? Science is so hard! Thanks
24 is 16% of what number
Which statement is inconsistent with the concept of isotopes of the same element? a. Isotopes have the same number of protons b. Isotopes have the same atomic n
2v2 -5v +3 = 0 how did I do this?
How does being physically fit affect your resting heart rate?
the product of two consecutive positive even integers is 14 more than their sum
What must sound energy move through to travel from source to receiver?
What is 2 to the 10th power in scientific notation
Compare and contrast ancient China and ancient Japan.  please help! i need to do an essay on it that is 3-5 paragraphs long.
What might happen to the sea star population after oyster beds are destroyed