Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
create table t1 (id int, first_name varchar(100), last_name varchar(100), score double); |
create index t1_name on t1 (first_name, last_name); |
insert into t1 values |
(1, 'Alice', 'Fowler', 5), |
(2, 'John', 'Doe', 6), |
(3, 'John', 'Smith', 6), |
(4, 'John', 'Smith', 6), |
(5, 'John', 'Smith', 7), |
(6, 'John', 'Elton', 8.1), |
(7, 'Bob', 'Trasc', 9), |
(8, 'Silvia', 'Ganush', 10); |
select first_name fn, last_name ln, row_number() over () rn |
from t1 |
order by rn desc; |
fn ln rn
|
Alice Fowler 1
|
Bob Trasc 2
|
John Smith 3
|
John Smith 4
|
John Smith 5
|
John Elton 6
|
John Doe 7
|
Silvia Ganush 8
|
The DESC keyword is being ignored.