Post reply

MySQL limit

  • October 25, 2005 at 7:59 am

    #102883

    Hi,

    I need the equivalent for below mysql query :

    select *from test limit 5, 20

    I know that the below is possible in SQL Server :

    select top 20 * from test where column1 not in (select top 5 column1 from test).

    But my problem is I want a generic solution wherein I will not be aware of the columns available within the table.

    Please advice

  • October 25, 2005 at 9:55 am

    #599857

    In sql server 2000 T-Sql does not have an equivelent to the limit command. In general sql server 2000 is behind the curve when it comes to paging, and ranking operations.

    Look to sql 2k5 to help with this problem.

    For a generic solution to span all RDBMS would be to do paging ClientSide. Otherwise There's no easy way.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply