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;
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?