-
Notifications
You must be signed in to change notification settings - Fork 3
SQL Test Queries ORDER BY
David Lidström edited this page Nov 4, 2017
·
1 revision
These are the tests and expected results for different ORDER BY queries.
These tests can be found in camlsql.sql_orderby_testqueries.spec.js
.
- "
SELECT * FROM List ORDER BY Field
",[]
- "
SELECT * FROM List ORDER BY [Field]
",[]
<View>
<Query>
<OrderBy>
<FieldRef Name="Field" />
</OrderBy>
</Query>
</View>
- "
SELECT * FROM List ORDER BY Field desc
",[]
- "
SELECT * FROM List ORDER BY [Field] desc
",[]
<View>
<Query>
<OrderBy>
<FieldRef Name="Field" Ascending="False" />
</OrderBy>
</Query>
</View>
- "
SELECT * FROM List ORDER BY Field, Field2
",[]
- "
SELECT * FROM List ORDER BY [Field], Field2
",[]
<View>
<Query>
<OrderBy>
<FieldRef Name="Field" />
<FieldRef Name="Field2" />
</OrderBy>
</Query>
</View>