Call Support +91-85588-96644
TCYonline

Login

Sign Up

Please enter a Username or Email ID
Please enter a password
Keep me logged in
Please enter your name
Please enter your mobile number
You can't leave Captcha Code empty
By submitting this form, you agree to the Terms & Privacy Policy.
OR

Sign Up via Facebook

Sign Up via Google

Sign Up via Twitter

Download Software
Tests given

Download TCY App

App Image

Which of the following queries will fetch all the Jeans that cost more than 2000 Rs?

Product Table:

Category Product_Name Product_Price State Country
Furniture Chair 700 Rs Colordo US
Furniture Bed 2000 Rs Colordo US
Electronics TV 1200 Rs Capetown Africa
Electronics Radio 700 Rs Delhi India
Leather Bag 800 Rs Mumbai India
Garments Jeans 2300 Rs Nairobi Kenya

 
SELECT product SET product_name='Jeans' WHERE product_price> 2000
UPDATE product _nameSET product_name='Jeans' WHERE product_price> 2000
UPDATE product SET product_name='Jeans' WHERE product_price> 2000
UPDATE product SET product_name='Jeans' WHERE product_price IN (Select MAX (product_price) from product)
None of the above

Reply


Please type your answer before submitting.
Submit

What's question?