MS SQL

[imported_pak9rabid]

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?

 

[igowerf]

Read the user comments here:
http://sillytech.com/threads/626

 

[kamper]

select top 10 from foo where key not in (select top 10 from foo)

That's how I've always done it (with appropriate order by clauses, of course).

 

[oog]

sql 2005 supports what oracle has had for a while--the concept of a rownum. you can base your queries off of it to limit your range. i don't remember what it was called though.