
SQL: Find all the products with a price between Rs.200 and Rs.600
SQL Basic Select Statement : Exercise-25 with Solution.
Write a SQL query to find all the products with a price between Rs.200 and Rs.600.
Sample table: item_mast
Sample Solution :
SELECT * FROM item_mast
WHERE pro_price BETWEEN 200 AND 600;
Output:
Query Visualization:
Duration:

Rows:

Cost:

Practice Online
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a SQL query to find all the details of 1970 winners by the ordered to subject and winner name; but the list contain the subject Economics and Chemistry at last.
Next: Write a SQL query to calculate the average price of all products of the manufacturer which code is 16.
What is the difficulty level of this exercise?
New Content: Composer: Dependency manager for PHP, R Programming