want similar functionality like limit function mysql

• VishalVasani

  Valued Member

  Points: 63

  More actions

  November 18, 2005 at 5:03 am

  #166644

  Hello

  I want similar funcationality like limit function in mysql. Any one know how to do this in mssql.

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  November 18, 2005 at 5:05 am

  #604596

  ..and what does 'limit' do in mySQL..?

  /Kenneth

• VishalVasani

  Valued Member

  Points: 63

  More actions

  November 18, 2005 at 5:16 am

  #604601

  Limit function in mysql allow to select records from records set

  e.g select * limit 3,10 from test

  fetch record in range

   

   

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  November 18, 2005 at 5:42 am

  #604608

  See the post at

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=135329

  SQL = Scarcely Qualifies as a Language