views query I can't workout

Question

I know the query I am trying to achieve. But how to start create it in views using drupal 7 alludes me. This is what I am trying to achieve

SELECT * from Articles where Node IS NOT current Node.

Answer 1

You need to use views contextual filters. Add a contextual filter Content:Nid and provide default value as "Content Id from URL" and select Exclude checkbox in the settings. That's it !!