Hello there,
I want to use sql limit and line number.
How can I do that?
Code |
---|
Select ..... limit, 5 |
or
Code |
---|
Select rank () .... |
or
Code |
---|
Select rownumber () ..... |
...
...
or
Code |
---|
Query = New Query; Query.Text = "SELECT | Table1.Code, | Table1.Description ////using row number or limit ?? |FROM | Catalog.Table1 AS Table1"; QueryResult = Query.Execute(); SelectionDetailRecords = QueryResult.Select(); |
Can you give an example?