Professional Web Applications Themes

How to get the last N records from a table - IBM DB2

Hi all, I am trying to come up with a sql query (just one query) that returns all the columns for the last N records that were inserted into a table. I have a column in the table that has the creation timestamp for each record. In other words, if a client requests to get only the latest 5 records, then this query shoud exactly do that: get all the columns for the last 5 records that were inserted into the table....

  1. #1

    Default How to get the last N records from a table

    Hi all,

    I am trying to come up with a sql query (just one query) that returns
    all the columns for the last N records that were inserted into a
    table. I have a column in the table that has the creation timestamp
    for each record. In other words, if a client requests to get only the
    latest 5 records, then this query shoud exactly do that: get all the
    columns for the last 5 records that were inserted into the table.
    Ricardo Guest

  2. #2

    Default Re: How to get the last N records from a table

    "Ricardo" <com> wrote in message
    news:google.com... 

    ORDER BY the creation timestamp column in DESCENDING sequence. Then use the
    FIRST n ROWS ONLY clause.


    Mark Guest

  3. #3

    Default Re: How to get the last N records from a table

    Don't forget to have an index if possible to attempt to reduce table access.

    --

    Bob
    Consulting I/T Specialist
    IBM Toronto Lab
    IBM Software Services for Data Management
    [My comments are solely my own and are not meant to represent an official IBM position - ask my cat!]
    "Mark A" <net> wrote in message news:jLmlb.1564$uswest.net...
    "Ricardo" <com> wrote in message
    news:google.com... 

    ORDER BY the creation timestamp column in DESCENDING sequence. Then use the
    FIRST n ROWS ONLY clause.


    Bob Guest

  4. #4

    Default Re: How to get the last N records from a table

    > > Hi all, 
    >
    > ORDER BY the creation timestamp column in DESCENDING sequence. Then use[/ref]
    the 
    You should probably create an index on the creation timestamp column and use
    the ALLOW REVERSE SCANS clause on the CREATE INDEX.


    Mark Guest

Similar Threads

  1. modify a field in all records of a table
    By Josselin in forum MySQL
    Replies: 1
    Last Post: May 4th, 06:11 AM
  2. How to get All Records in Table A that don't havematching ID in Table B
    By Photoshare in forum Coldfusion Database Access
    Replies: 4
    Last Post: February 23rd, 10:46 PM
  3. recordcount 0 but records in table
    By speedyG in forum Macromedia ColdFusion
    Replies: 1
    Last Post: June 3rd, 05:19 PM
  4. Delete from one table with matching records in another table
    By Dale Fye in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 1st, 01:28 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139