Multiple sql queries

[fantom]

Thank you for your response! You are right i forgot to bind the value.

Concerning the second query could you please tell me how i have to write it in order to take the first value of the Client table?

[Lesiok]

Thank you for your response! You are right i forgot to bind the value.

Concerning the second query could you please tell me how i have to write it in order to take the first value of the Client table?

Try this SQL :

SELECT * FROM Clientwhere ORDER BY here_def_of_sort LIMIT 1

SELECT * FROM Clientwhere ORDER BY here_def_of_sort LIMIT 1

To copy to clipboard, switch view to plain text mode 

but LIMIT is an extension of SQL language and in different databases it has different construction. This is correct for PostgreSQL and MySQL in example. For DB2 it is

SELECT * FROM Clientwhere ORDER BY here_def_of_sort FETCH FIRST 1 ROWS ONLY

SELECT * FROM Clientwhere ORDER BY here_def_of_sort FETCH FIRST 1 ROWS ONLY

To copy to clipboard, switch view to plain text mode 

.