cancel
Showing results for 
Search instead for 
Did you mean: 

limit results of select statement

alberto_colonna
Participant
0 Kudos

<b>Hello everybody</b>,

How can I limit the results of a select statement.

For example I want to show only the results from line

4 to line 10. I use a MaxDB database.

In MySQL the command is called "LIMIT", but I can't find

a similar SQL - command for the MaxDB.

Can you help me?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

hi ,

sure this mysql manual will help you to solve the problem .

http://dev.mysql.com/doc/refman/5.0/en/select.html

Thanks

Varun

alberto_colonna
Participant
0 Kudos

Thank you for your answers.

I have still the problem, that the command "ROWNO" only

works if you want to show the lines < a number.

For example < 5.

But how can I start with line 4 or another line?

Best regards

Alberto

kishorg
Advisor
Advisor
0 Kudos

Hi Alberto ,

just follow this link.

http://dev.mysql.com/doc/maxdb/en/8c/ccce30c71c11d2a97100a0c9449261/content.htm

Regards

Kishor Gopinathan