Overview
| Artifact ID: | 893842f274972850856a9be94ab92e2ea036ac4c |
|---|---|
| Ticket: | 8f05349da78773f4dfc29ace794ad174b909917b
Support for windowing functions in Sqlite EF6 |
| User & Date: | anonymous 2019-04-03 08:59:16 |
Changes
- icomment:
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> - login: "anonymous"
- mimetype: "text/x-fossil-wiki"