Register
Which ORDER BY clause causes 10 rows to be retrieved from the result set, starting with the 20th row?
141k views
4 votes
Which ORDER BY clause causes 10 rows to be retrieved from the result set, starting with the 20th row?

User Krejko
by
7.6k points

1 Answer

3 votes
Limiting the number of results to 10 is typically not achieved in the ORDER BY clause. You would do it with the TOP or LIMIT or ROWNUM keyword, depending on your database technology.


User DialFrost
by
7.9k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

8.8m questions

11.4m answers

Other Questions

“What does it mean when we “rework” copyrighted material?”
The book shows how to add and subtract binary and decimal numbers. However, other numbering systems are also very popular when dealing with computers. The octal (base 8) numbering system is one of these.
Seven basic internal components found in a computer tower
Explain why binary codes are used to represent characters, numbers and symbols :)
What is an example of a dedicated computer system?
Link Copied!