Ticket Change Details
Not logged in

Artifact ID: 893842f274972850856a9be94ab92e2ea036ac4c
Ticket: 8f05349da78773f4dfc29ace794ad174b909917b
Support for windowing functions in Sqlite EF6
User & Date: anonymous 2019-04-03 08:59:16

  1. icomment:
    on further thought, the second example would translate more like this if you were to use sql server EF6:
    select [all columns except rownum]
    from ( select *,
                  row_number() over (partition by col1 order by col2) rownum
           from table ) x
    where x.rownum = 1
  2. login: "anonymous"
  3. mimetype: "text/x-fossil-wiki"