Results 1 to 3 of 3

Thread: Record Select

  1. #1
    Join Date
    Jul 2004
    Posts
    268

    Unanswered: Record Select

    Hi All,

    I have a column in a table that has the data that looks like this:

    1 1234 somewhere street
    2 45a main rd
    3 124A work ave
    4 new street

    I need to pull records 2 and 3 only. Any ideas?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Code:
    select first_column_value, second_column_value
    from your_table
    where first_column_value in (2, 3)
    [EDIT] On a second thought, it can't be that simple, can it?

    Anyway: there must be *something* you can order those records by. If it is really a column which contains a number (1, 2, 3, 4 in your example), no problem. If not, what do you sort records by? If there's nothing there, how can you tell which record is the second and which is the third? You can't!

    So, I guess you'll have to give some more information.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Rows in a table are like balls in a basket.

    How do you identify the 2nd ball in a basket?
    If you can do so, then use same process on your table data.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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