WOLFRAM

Wolfram Language & System Documentation Center
Wolfram Language Home Page »
DatabaseLink`
DatabaseLink`

SQLResultSetTake

SQLResultSetTake[rs,{m,n}]

reads rows m through n from a result set.

Details and Options

Examples

open allclose all

Basic Examples  (1)Summary of the most common use cases

In[1]:=1
✖
https://wolfram.com/xid/0h7bl1g0ehshxuz0xs-ckws21

If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseLink`DatabaseExamples` package, as described in Using the Example Databases.

Open a connection:

In[2]:=2
✖
https://wolfram.com/xid/0h7bl1g0ehshxuz0xs-ccg

Open a result set:

In[3]:=3
✖
https://wolfram.com/xid/0h7bl1g0ehshxuz0xs-id4
Out[3]=3

Get rows 2 through 4:

In[4]:=4
✖
https://wolfram.com/xid/0h7bl1g0ehshxuz0xs-tnp
Out[4]=4

Get the last three rows:

In[5]:=5
✖
https://wolfram.com/xid/0h7bl1g0ehshxuz0xs-rr8
Out[5]=5

Close the result set:

In[6]:=6
✖
https://wolfram.com/xid/0h7bl1g0ehshxuz0xs-k7h
In[7]:=7
✖
https://wolfram.com/xid/0h7bl1g0ehshxuz0xs-tp1

Options  (1)Common values & functionality for each option

"GetAsStrings"  (1)

In[1]:=1
✖
https://wolfram.com/xid/0h7bl1g0ehshxuz0xs-is93to
In[2]:=2
✖
https://wolfram.com/xid/0h7bl1g0ehshxuz0xs-g5z
In[3]:=3
✖
https://wolfram.com/xid/0h7bl1g0ehshxuz0xs-v34
In[4]:=4
✖
https://wolfram.com/xid/0h7bl1g0ehshxuz0xs-dch
In[5]:=5
✖
https://wolfram.com/xid/0h7bl1g0ehshxuz0xs-gm0
In[6]:=6
✖
https://wolfram.com/xid/0h7bl1g0ehshxuz0xs-v2w