Post reply

Rows in a table

  • October 13, 2009 at 9:21 am

    #134502

    Hi,

    I have two concerns here, plz help me out.

    1) I have one DB table with one column and with 1000 records(rows). Now I need to display the records which are from 200 to 300.

    2) Two users are entering the data in to the some DB table through application.

    Now here in this

    A) Need to display the data userwise.

    B) How to retrive the recent inserted row.

    Thanks in advance.

  • October 13, 2009 at 9:34 am

    #1065262

    For the first question, look up ROW_NUMBER(), you should be able to apply it to a query pretty easily.

    For the second, i'm not too sure what exactly you're looking for...

    BUT, if you want to keep track of which users enter which data, have a USERID column, or something of the sort. To find recent entries, add a timestamp using GETDATE(), whenever a row is added.

    Is this homework?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply