> select id,lot_id,lot_type from scrap_table
> <starting with record 1932> (part I need help with)
> order by id limit 10;
>
> which should give me records 1932 - 1942 like this...
>
> +------+----------+----------+
> | id | lot_id | lot_type |
> +------+----------+----------+
> | 1942 | 0034906 | F |
> | 1941 | 0100308 | F |
> | 1940 | 0036309 | S |
> | 1939 | 0033503 | F |
> | 1938 | 0034108E | D |
> | 1937 | 0034712 | F |
> | 1936 | 0029404 | F |
> | 1935 | 0032706 | F |
> | 1934 | 0029404 | F |
> | 1933 | 0100307 | F |
> | 1932 | 0100404 | F |
> +------+----------+----------+
If you simply needed the exact result here's the query
SELECT id,lot_id,lot_type FROM scrap_table WHERE
id BETWEEN 1932 AND 1942
ORDER BY id DESC
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
