Hello!

Please see the TOP command in your Books on-line... select top 10 * from
table ...

Cheers,
Dejan
"Urban" <klabinks@tlen.pl> wrote in message
news:co76ls$lka$1@news.zigzag.pl...
| hi,
|
| I have a question.
| Maybe You know the equivalent to command LIMIT from MySQL
| I couldn`t find something like this in MS SQL
| PS
| I try to display 10 records begining form e.g. 4 sort by id
| something like: "SELECT * FROM table WHERE name=... LIMIT 4, 10 ORDER BY
id"
| in MySQL
|
| thanx,
| Urban
|
|