programming-examples/Write a SQL query to find the name and price of the cheapest item.sql at master - programming-examples - michuIT: Everything is code

You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

5 lines

191 B

SQL

Raw Permalink Blame History

 /*Write a SQL query to find the name and price of the cheapest item.*/
 SELECT pro_name, pro_price
    FROM item_mast
    WHERE pro_price =
     (SELECT MIN(pro_price) FROM item_mast);