Question

1. Which of the following will produce the minimum of all standard prices?

   		Select standard_price from Product_V where Standard_Price = min;
   		Select min(standard_price) from Product_V;
   		Select Standard_Price from min(Product_V);
   		Select min(Standard_Price) from Product_V where Standard_Price = min(Standard_Price);

Answer 1

Sol:

Its taking the minimum value from the column standard prices

with min function in sql you get the required output

Execute belwo query

data Product_V ;
input standardprice;
infile cards;
cards;
50
20
30
0
10
100
;
run;
proc sql;
select min(standardprice) from Product_V;
quit;

after we executed the abpove query output is

Select min(standard_price) from Product_V;