How limit a simple SELECT FIELDSX FROM MyTABLE

, , , , ,
1

Hi!

I try make select record from a ADABSE Tables with one ODBC with some script JSP (java)



	con=DriverManager.getConnection("jdbc:odbc:YourId;APPLICATION=YourFrame; Uid=YourUser;");
	Statement st = con.createStatement();

	sql = "SELECT  "+champs+" as col1 FROM YourFrame.dbo."+DDM+" WHERE  "+champs+" LIKE '"+requete+"%' OR "+champs+" 
                            LIKE '%"+requete+"%' ";

                rs = st.executeQuery(sql);

and the code is running

But I want have a similar mySQL instruction as

SELECT champs FROM YourFrame.dbo.DDM WHERE blabla… LIMIT 0, 5

How have a similar instruction with the sql of ConnX ?

Thanks

Bernie_liege

2

Please consider using the SQL Extended Function {maxrows #}

This keyword limits the number of rows that are returned.

Example:

SELECT * FROM customers {maxrows #}