SELECT ProductID, ProductName, SupplierID, CategoryID, Unit, Price FROM Products where Price in (select max(price) from Products)
Union
SELECT ProductID, ProductName, SupplierID, CategoryID, Unit, Price FROM Products where Price in (select min(price) from Products);
1. SELECT MAX(PRICE) AS MAX_PRICE, MIN(PRICE) AS MIN_PRICE FROM PRODUCTS;
2. SELECT PRODUCTNAME,PRICE FROM PRODUCTS WHERE PRICE IN (SELECT MAX(PRICE) FROM PRODUCTS)UNION
SELECT PRODUCTNAME,PRICE FROM PRODUCTS WHERE PRICE IN (SELECT MIN(PRICE) FROM PRODUCTS);
If you are facing any issue like can not see video so please login into Google with email what you forwarded to us Google Login or mail to administrator qatraining@infotek-solutions.com
March 14, 2015 at 11:02 pm
SELECT ProductID, ProductName, SupplierID, CategoryID, Unit, Price FROM Products where Price in (select max(price) from Products)
Union
SELECT ProductID, ProductName, SupplierID, CategoryID, Unit, Price FROM Products where Price in (select min(price) from Products);
March 16, 2015 at 1:44 am
1. SELECT MAX(PRICE) AS MAX_PRICE, MIN(PRICE) AS MIN_PRICE FROM PRODUCTS;
2. SELECT PRODUCTNAME,PRICE FROM PRODUCTS WHERE PRICE IN (SELECT MAX(PRICE) FROM PRODUCTS)UNION
SELECT PRODUCTNAME,PRICE FROM PRODUCTS WHERE PRICE IN (SELECT MIN(PRICE) FROM PRODUCTS);
March 22, 2015 at 10:26 pm
select max(price) as costliest from products;
UNION
select min(price) as cheapest from products;
March 25, 2015 at 4:57 pm
select max(Price)from producst;
union
select min(price) from products;
March 26, 2015 at 7:51 pm
Select max (Price) from products ; union
Select min (Price) from products;
September 20, 2015 at 3:57 am
SELECT MAX(PRICE) as ‘costliest’, MIN(PRICE) as ‘cheapest’ FROM PRODUCTS;
Navigation
Loading Questions
If you are facing any issue like can not see video so please login into Google with email what you forwarded to us Google Login or mail to administrator qatraining@infotek-solutions.com
Edit Profile