- Aug 22, 2004
- 107
- 0
- 0
so..i couldn't help but notice when trying to write queries for microsoft's database implementations that there is no LIMIT command. whats the deal with that? The closest I could find was using TOP <number> after select. For example:
SELECT TOP 10 *
FROM myTable
WHERE myField = 'some value';
as opposed to:
SELECT *
FROM myTable
WHERE myField = 'some value'
LIMIT 10;
Microsofts version works fine and dandy, until you need to do something like limit the range of results from say 10 to 20
Is there a way to do the same thing with microsoft's implementation of SQL?
Is Microsoft once again not abiding by ANSI standards, or is the LIMIT feature just something that's specific to MySQL?
SELECT TOP 10 *
FROM myTable
WHERE myField = 'some value';
as opposed to:
SELECT *
FROM myTable
WHERE myField = 'some value'
LIMIT 10;
Microsofts version works fine and dandy, until you need to do something like limit the range of results from say 10 to 20
Is there a way to do the same thing with microsoft's implementation of SQL?
Is Microsoft once again not abiding by ANSI standards, or is the LIMIT feature just something that's specific to MySQL?