Sorry, may be a stupid question. 
I have 2 tables with parent - child relationship. For each parent, there are more than 10 records in the child table. I want to get only 3 records from child table for each parent. Is it possible with one query in mysql ?