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 greatest legacy of Dr Jose P Rizal to the present day Filipinos?​
A large university accepts ​60% of the students who apply. Of the students the university​ accepts, ​45% actually enroll. If 20,000 students​ apply, how many ac
The side of a square is 2.5 cm. Find its perimeter and area.​
2x^2+3x+4=0 Solve using quadratic formula
What are the variables? Describe how the variables are related at various points on the graph.
Which of the following is an independent clause? As the headlines worldwide have reported Although developmental psychologist often say that personality is for
Answer the following, will give brainliest!
Part 1 of 2 Sarah took the advertising department from her company on a round trip to meet with a potential client. Including Sarah a total of 12 people took th
16 ÷ 36,864 Please solve
A positive attitude at work is important because it: