The DEFAULT RANGE

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

dawryn SSCertifiable Points: 5479 More actions · Answer 1

There is not enough information in the question to answer without doubt.

It depends whether ORDER BY is specified or not and which function is used.

Steve Jones - SSC Editor SSC Guru Points: 736115 More actions · Answer 2

There is a default range regardless of the order by. However, an ORDER BY is required to have rows/range applied.

I've amended the question to note there is an ORDER BY.

dawryn SSCertifiable Points: 5479 More actions · Answer 3

Yes, there is default range but it was not given as result of original question.