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 is the correct order of the life cycle for a star with a solar mass less than 8? Reorder answers 1.Protostar Reorder answers 2.Main Sequence Reorder answ
What is the best brand of seat covers?
ayuda porfa es para hoy​
Find the new amount that marks the increase or decrease given. An increase of 68% in 832
Which equation describes this line? ++ -10 (-3, 2) A. y 102(x-1) B. y 2 2(x-3) C. y 1 2(x-10) D. y 3 2(x-2) 10-(1, 10) -10+ 10 SUBMIT
why is the reynolds political map three different colors
Find the acceleration of the two blocks sliding down the incline in the figure below. (Take m1 = 1.1 kg and m2 = 2.4 kg. Indicate the direction with the sign of
Tomasz purchased a new heating and air-conditioning system for his home and financed $5,300 at an annual interest rate of 3.9% compounded monthly for 3 years. H
when is the fregar deal
Find y′ implicitly from the equation 3x + 5y = x3 + y.