w3resource
SQL exercises

SQL: Find the item name and price in Rs.

SQL Basic Select Statement : Exercise-27 with Solution.

Write a SQL query to find the item name and price in Rs.

Sample table : item_mast

 

Sample Solution :

 SELECT pro_name as "Item Name", pro_price AS "Price in Rs."
    FROM item_mast;

Output:

SQL exercises

Query Visualization:

Duration:

Query visualization of Find the item name and price in Rs. - Duration

Rows:

Query visualization of Find the item name and price in Rs. - Rows

Cost:

Query visualization of Find the item name and price in Rs. - Cost

Practice Online


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

Previous: Write a SQL query to calculate the average price of all products of the manufacturer which code is 16.
Next: Write a SQL query to display the name and price of all the items with a price is equal or more than Rs.250, and the list contain the larger price first and then by name in ascending order.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming