B4J Question how combine two sql query

[behnam_tr]

hi

i want to combine two sql query

Dim RS As ResultSet=Sql1.ExecQuery2("SELECT * FROM tbl WHERE userid = ? ", Array As Int(uid))
    Dim RS As ResultSet=Sql1.ExecQuery2("SELECT * FROM tbl OFFSET LIMIT ?,?",Array As String(0,10))

how do i this ??

 

[jmon]

I guess with UNION?:
http://www.mysqltutorial.org/sql-union-mysql.aspx

Dim s As String = $"
SELECT * FROM tbl WHERE userid = ?
UNION
SELECT * FROM tbl OFFSET LIMIT ?,?"$
Dim RS As ResultSet=Sql1.ExecQuery2(s, Array (uid, 0,10))

 

[behnam_tr]

thanks i check this
i mean i want select 10records where userid=x from tbl

 

[jmon]

How about that? That selects 10 rows where the column userid = uid

Dim s As String = $"
SELECT * FROM tbl WHERE userid = ? LIMIT ?;"$
Dim RS As ResultSet=Sql1.ExecQuery2(s, Array (uid,10))

 

[behnam_tr]

i check this but it select all rows

    Dim s As String = $"
SELECT * FROM hesabdari WHERE userid = ?
UNION
SELECT * FROM hesabdari OFFSET LIMIT ?,?"$
    Dim RS As ResultSet=Sql1.ExecQuery2(s, Array (uid, counter,19))

first shuold i select all row where uid=x
then i want to select 0-10 rows or x-y row from rows that fetched from first step
maybe first step return 50 rows i want select 0-10 records or 10-20 records (start pos- end pos)
ok ??

 

[DonManfred]

i mean i want select 10records where userid=x from tbl

why two sql then for this if it can be done with ONE simple SQL like @jmon suggested in #4

 

[DonManfred]

but i want select rows 0-10 or 10-15 or x-y with offset where uid=x

use LIMIT

LIMIT 0,10 (0 to 9)
LIMIT 9,5 (10 to 15)

something like

Dim s As String = $"
SELECT * FROM tbl WHERE uid = ? LIMIT ?,?;"$
Dim RS As ResultSet=Sql1.ExecQuery2(s, Array (uid,9,5))

I strongly suggest to learn the SQL Language basics.

 

[behnam_tr]

use LIMIT

LIMIT 0,10 (0 to 9)
LIMIT 9,5 (10 to 15)

something like

Dim s As String = $"
SELECT * FROM tbl WHERE uid = ? LIMIT ?,?;"$
Dim RS As ResultSet=Sql1.ExecQuery2(s, Array (uid,9,5))

I strongly suggest to learn the SQL Language basics.

thanks guys
solved with this