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.
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 !!