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

How do you find the rule to this sequence 1,2,3,5,8,13,21. Is it the Fibonacci sequence?
what countries make up sachel region
Benny bought 4 new baseball cards to add to his collection. The next day his dog ate half his collection. There are now only 41 cards left. How many didhe start
Where do rock slides happen often
Hi. Could someone please help me help my son with his homework. TIA For every 4 miles Vanessa jogged, Cody jogged 3 miles. If Vanessa jogged 1 miles, how far wo
How do I solve n x 43.50= 435
how was palace of Versailles a perfect example of baroque art?
Multiply write each product in simplest form 5/8×24
a new concept that is tested in a scientific investigation is known as
What is a fifth of 60