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

Major lamndforms for Louisiana
if donald builds 32 desks how many screws will he need
What's the main cause of an aurora
Find the area of a triangle with a base of 27 feet and a height of 14 feet. A) 41ft^2 B)82ft^2 C)189ft^2 D)378ft^2
Which place is home for the first known written code of law? (a) Egypt (b) Mesopotamia (c) Both (d) neither
At what temperature does pure water freezes on the celsius scale?
49 The list shows the number of songs that five students each downloaded last week. 32, 43, 38, 28, 51 What is the mean absolute deviation of the numbers in the
what is the place and time in The Nuking of america
Match each linear equation to the appropriate description: Column A 1. : 2. : 3. : 4. : Column B a. A linear eq
What temperature does water freeze and boil in fahrenheit and celsius?