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

Can concussions kill you?
Given the equations 2x + 2y = 16 and 4x - 3y = -3, what are the values of x and y?
The endosymbiotic theory provides an explanation for the origin of chloroplasts. Which trait of chloroplasts supports this explanation?
Choose the Korean particle that is being used correctly: a) 저는 공원를 갔어요 b) 저는 펜을 있어요 c) 나는 친구가 만났어 d) 나는 병원 옆에 있어
(1) Earths crust is made up of relatively rigid plates that ride atop Earth's hot, semiliquid mantle. (2) The plates are called tectonic because they're in cons
based on location in the periodic table, what is the formula for beryllium chloride?
Estimate by first rounding each number to the nearest integer. 4 1/9 + 2 2/13 A. -7 B. -6 C. 6 D. 7
What is the slope of the line 5y = –3x + 10 ?
When you take a deep breath before diving underwater, air is forced into your lungs by the contraction of your.. -alveoli -lungs -diaphragm -heart
In comparing an oak tree with a maple tree, you can correctly say that A. Both maple and oak trees lose their leaves in the fall. B. Unlike oak roots, maple ro