Limit In SQL Statement

Results 1 to 2 of 2

Thread: Limit In SQL Statement

  1. #1
    Join Date
    Dec 1969

    Default Limit In SQL Statement

    Is it possible to use LIMIT in your SQL statement (SELECT * FROM news LIMIT 2) and if you cannot then how could i just select 2 records and not the whole set of data?

  2. #2
    Join Date
    Dec 1969

    Default RE: Limit In SQL Statement

    Of course it depends on which 2 records that you want to select. If you just want the first 2 records, you could do this:<BR><BR>SELECT TOP 2 * FROM tblName

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts