TOP 15 Records - Help

Results 1 to 4 of 4

Thread: TOP 15 Records - Help

  1. #1
    Nick Forte Guest

    Default TOP 15 Records - Help

    How can I get the top 15 records entered from a db? Either SQL or ASP, preferrably SQL. THANKS

  2. #2
    Join Date
    Dec 1969

    Default RE: TOP 15 Records - Help

    Try this. "Select * top 15 from tblName". Substitute tblName with the actual name of your table. Add a where and/or order clause to finetune your selection eg "Select * top 15 from Customer where City = &#039Kuala Lumpur&#039 order by Country.

  3. #3
    Nick Forte Guest

    Default RE: Doesn't work

    I&#039m using MS Access. I don&#039t think this is allowed. I get a syntax error. &#039SELECT * top 15 FROM FCC_RELEASES ORDER BY CREATED_DT&#039

  4. #4
    Johnny Kid Guest

    Default RE: Doesn't work

    Hey, it should be<BR><BR>&#039SELECT top 15 * FROM ......&#039<BR>instead of <BR>&#039SELECT * top 15 FROM ......&#039<BR>ok?<BR><BR>

Posting Permissions

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