Here I am trying to fetch products along with prices but here one condition is there that is title should be unique in results.
example: Nokia lumia 730 has three rows but I need to fetch only one row by giving price range in that category.
Please look here for schema
You can use : GROUP BY .
SELECT DISTINCT p.* from products AS p LEFT JOIN price AS p1 on p1.product_id=p.id WHERE p1.price >= '2000' AND p1.price <= '10000' AND p.category IN (6) GROUP BY title;