Post reply

return value

  • February 24, 2011 at 3:34 pm

    #234997

    data

    ID

    1

    2

    3

    4

    5

    6

    7

    8

    9

    10

    ...

    1000000

    how would I write a select statement that would only return the 10th ID: for example: id = 10, 20,30,40, ....

    Thanks for all the help

  • February 24, 2011 at 3:35 pm

    #1291320

    Well, are you familiar with the modulo operator?

    Such as:

    SELECT ID FROM table WHERE id%10 = 0

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • February 24, 2011 at 6:15 pm

    #1291340

    thanks Craig! That works.

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

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