Wordpress limiit query results

Question

How can I limit query result in wordpress let's say I want to display just 4 last posts from a category but starting from second row, I know that in MySql is like this:

select * 
from table_name 
limit 4, 1

In wordpress should be something like this:

('cat' => get_category_id($catname), 'posts_per_page' => 2, 1);

But it is not working

Answer 1

I found the solution, i just needed to use the offset variable instead of paged.

Check here for details

http://wordpress.org/support/topic/query_posts-offset-and-pagination

Answer 2

Use the paged (and the $paged WordPress variable) argument. All info here : http://codex.wordpress.org/Pagination#Adding_the_.22paged.22_parameter_to_a_query