Geek asks and answers

How does the FIRST_VALUE () function in Oracle process strings if there is no sentence in order?

The definition of first_value () indicates that it returns the first value in an ordered dataset. Syntax:

First_Value (ColumnName) over ([Partit By Colum] [Order by Column])

The By and Order By sections are optional. If the by section is deleted, we get the first value of the whole set.

My question is, what can we get if Order By is deleted? Does the oracle implicitly order the set or just give a random first value or give the first value for data entry?

+3
source share
1 answer

, ORDER BY, , Oracle . .

+4

More articles:


All Articles