Computer Science, asked by sayyambakshi20, 11 months ago

solve this fast✌️........................​

Attachments:

Answers

Answered by Amaie
1

a)The field P_Id is the primary key because it is a unique field in the given table.

b)select*from Product where Price='50-100' ;

c) select* from Product where Product_Name='XYZ';

d)UPDATE PRODUCTS SET PRODUCT_NAME= 115 WHERE FACE WASH;

e)INSERT INTO ( "P_ID", "PRODUCT_NAME", "MANUFACTURERS",

"PRICE")

VALUES('F216', 'Shampoo', 'LAK', 260);

f) select*from products where P_Id='B501';

g) Alphanumeric

h) DELETE FROM PRODUCT WHERE PRODUCT ID=SHO6;

i) select* from Products order by 'Product_Name' DSC

j)select*from Products where Price='65'

NOW BETTER MARK IT AS THE BRAINLIEST ANSWER BCUZ I SPENT TOO MUCH TIME ON IT.


sayyambakshi20: thnx
Similar questions