﻿ SQL: Find all the products with a price between Rs.200 and Rs.600. - w3resource

# SQL: Find all the products with a price between Rs.200 and Rs.600

## SQL Basic Select Statement: Exercise-25 with Solution.

From the following table, write a SQL query to select a range of products whose price is in the range Rs.200 to Rs.600. Begin and end values are included. Return pro_id, pro_name, pro_price, and pro_com.

Sample table: item_mast

Sample Solution :

``````SELECT * FROM item_mast
WHERE pro_price BETWEEN 200 AND 600;
``````

Output of the Query:

```pro_id		pro_name	pro_price	pro_com
102		Key Board	450.00		16
103		ZIP drive	250.00		14
104		Speaker		550.00		16
109		Refill cartridge 350.00		13
110		Mouse		250.00		12
```

Relational Algebra Expression:

Relational Algebra Tree:

## Query Visualization:

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?

﻿