SQL question...

Results 1 to 4 of 4

Thread: SQL question...

  1. #1
    Al Bear Guest

    Default SQL question...

    is there a way to get a serise of records. e.g I want to select all record between two set values?? say 50 and 100.

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL question...

    select * from table where value between value1 and value2....<BR><BR>R&D Select statement....

  3. #3
    Medieval Dude Guest

    Default RE: SQL question...

    I&#039;m not sure about yer question because it could be either one of these questions:<BR>1. How do I get the TOP 50-100 records? <BR>For this, check the FAQ about setting up pages where you have 1-X number of records per page with a next and previous option.<BR><BR>2. How do I get records that have a field with a value BETWEEN 50 and 100?<BR>For this, of course you could simply do SELECT * FROM mytable WHERE myfield &#062;= 50 AND myfield &#060;= 100

  4. #4
    Al Bear Guest

    Default Thx

    Yep number two...

Posting Permissions

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