To make Limit clause as I typically do in MySQL

Asked By Seth Fisher 0 points N/A Posted on - 04/06/2012

How can I make Limit clause as I typically do in MySQL?  Will you please help me? Thanks! 

• Status: Open
• Question Views: 1286
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Interbase / Firebird

Best Answer by Allen Kenneth

Go To Solution

Answered By Estillero State 5 points N/A #104876

To make Limit clause as I typically do in MySQL

Hi Seth,

There is an equivalent SQL clause for LIMIT on FireBird. As far as I know the support start on FireBird 1.0.3. Using the FIRST keyword you can mimic the LIMIT clause in MySQL. There is also a keyword called SKIP to skip rows you don't want to show.

Here is a sample of how to do it:

SELECT FIRST 10 column1, column2, column3, column4 from TABLE1

To use SKIP with FIRST clause:

 

SELECT FIRST 10 SKIP 20 column1, column2, column3, column4 from TABLE1

Rows 21-30 will be displayed when the above query is executed.

 

I hope it helps.

 

About Estillero State

Questions
7

Answers
70

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 04/19/2012
• Question Category: Interbase / Firebird

Best Answer

Best Answer

Answered By Allen Kenneth 20 points N/A #104877

To make Limit clause as I typically do in MySQL

 

Hello Seth,

 

There is a  LIMIT clause in Firebird which is much similar to that of MySQL's LIMIT syntax.

This is very useful in situations where you bother  to run the database cursor over multiple requests and very useful when you want  the database to return back the most relevant result, over a large result set sometimes

This is working fine in Firebird 1.0.3.
 

  SELECT FIRST x [SKIP y] … [rest of query]

This syntax will return 'x' number rows of result from the query, and optionally skip first 'y' number of rows. 
 

Here is an example you might want to take a close look, it returns back row 21-30 from a query 

  SELECT FIRST 10 SKIP 20 column1, column2, column3 FROM foo
 

Recall the similar syntax or statement used in MySQL:

  SELECT column1, column2, column3 FROM foo LIMIT 10, 20

Hope you will get something out of this.

About Allen Kenneth

Questions
1

Answers
100

Best Answers
74

• Vote Up 0 Vote Down

• Posted on - 12/12/2012
• Question Category: Interbase / Firebird