Common Mysql Query

Here are the list of some commonly used mysql queries and their result...

1. SELECT  EXTRACT(YEAR_MONTH FROM NOW() - INTERVAL 2 MONTH )

Output: 201506

you can also add any useful mysql query in this post's comment section.