System.Data.SQLite
Ticket Change Details
Not logged in
Overview

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

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