+ Reply to Thread
Results 1 to 2 of 2

Thread: Select Statement - Need Help

  1. 09-25-2003 08:19 AM #1
    Guest.Visitor Guest

    Default Select Statement - Need Help

    How to select table using TOP. I have an sql and I just want to select only the top records. I can do it on sql server like "Select Top 1". Any help will be appreciated. Thanks, Rod Cortejo
    Reply With Quote Reply With Quote
  2. 09-25-2003 08:19 AM #2
    K.Forsythe Guest

    Default Select Statement - Need Help

    Rod, Some database languages add their own features tat are not part of the ANSI standards. TOP is one such feature. DB2 tries to implement the ANSI standards and so TOP is not supported. What exactly is the result you are trying to achieve? Kevin
    Reply With Quote Reply With Quote
+ Reply to Thread

Similar Threads

  1. Using a variable in an SQL select statement.
    By Guest.Visitor in forum Java
    Replies: 2
    Last Post: 06-18-2007, 07:44 AM
  2. READE in a Select Statement
    By MichaelAiese in forum RPG
    Replies: 4
    Last Post: 10-02-2003, 10:30 AM
  3. Select Statement
    By Guest.Visitor in forum Programming
    Replies: 1
    Last Post: 12-27-2001, 11:16 AM
  4. Using IN in Select statement
    By dchristie in forum Programming
    Replies: 1
    Last Post: 02-16-2001, 09:50 AM
  5. SELECT statement
    By Guest.Visitor in forum Programming
    Replies: 6
    Last Post: 08-04-2000, 02:53 PM

Posting Permissions

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

Forum Rules