Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Krucifyx

  1. Krucifyx

    Limiting returned rows

    Wow, that's a lot of work for something that should be otherwise rather simple to pull off. In MySQL it would be: select * from company order by co_name limit 25,10 You'd think this would be a common enough thing that mssql would have something similiar.
  2. Krucifyx

    Limiting returned rows

    Ok, but that only return the first 10 rows, what if I wanted rows 11-20?
  3. Krucifyx

    Limiting returned rows

    I've looked around to see how to limit the rows returned from a query and I've come across TOP etc., but it's not what I'm looking for. With MySQL you can use LIMIT start,limit - so for example I'm browsing an archive of pages with 10 items per page, and I'm viewing page 4, it would be...
See more

Part and Inventory Search

Back
Top