JDBC

[manikandan malathy]

I have one problem in my program...

In my table contain 50 records... I am using mysql database.

How to getting every 5th record in my table give any sample code....

[Campbell Ritchie]

Please use a subject which tells what the post is about.
I think this is more appopriate for another forum, so I shall move you.

[Paul Campbell]

You have to rank the rows and use modulus to skip rows... something like this:

SELECT z.some_column
  FROM (SELECT a.some_column,(SELECT count(*)
                                FROM some_table b
                               WHERE b.some_column <= a.some_column) AS rn
          FROM some_table a) z
 WHERE mod(z.rn,5) = 1    

In Oracle and DB2 you you have can use the built-in functions to do it in a little cleaner way... something like this:

 SELECT some_column
  FROM (SELECT ROW_NUMBER( ) OVER (ORDER BY some_column) rn, some_column
      FROM some_table) x
 WHERE mod(rn,5) = 1   

[manikandan malathy]

i am executing this query some error will occur....


Error Msg in MySQL:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) from sample b
where b.emp_no <= a.emp_no) as rn from sample a) z where mod ' at line 1

[Campbell Ritchie]

MySQL error messages are hardly informative. If you want us to help, please quote the entire SQL statement which produces that error. It may be something tiny like a spelling error.