View Single Post

   
  #1 (permalink)  
Old 02-29-2008, 04:57 AM
Urban
 
Posts: n/a
Default LIMIT in MS SQL ??!!

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


Reply With Quote