Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

SQL Statement

Comment:

I am trying to query database: there 1000 records and i need row number 120th. How do i write a quesry for this. I hope someone will help me out. Atif

Reply:

what database? if it's mysql I think it'll be better if you can look for some specific part of that 120th row (like the ID)... if not, (assuming it's mysql), you can look for that 120th row after sorting them by doing this: SELECT * FROM `table_name` ORDER BY `order_column` LIMIT 119,1;

0

C++ Error

Open a cash drawer in acc...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: CAN ANYONE HELP ME WITH THIS SQL STATEMENT. I AM POLULATING A BUNCH OF TEXT BOXES ON A VB6 FORM WITH DATA FROM AN ACCESS DB USING ADO. THE SQL STATEMENT I HAVE WORKS, BUT IT ALSO RETURNS THE SAME THIN...

Summary: I'm trying to write an SQL statement that will run within VB6 using ADO. Every time I try and run it I get the error message: ORA-00903: Invalid Table Name A shortened example of the SQL is as follows...

Summary: Hi, im having problem in SQL statement in Visual Basic i declared strSQL as string Dim strSQL as String strSQl = "select * from college where name =" &str& ";" (all in one line) where str is a string....