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); |
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;
Get Answers For Free
Most questions answered within 1 hours.