No products in the cart.

"""Write SQL queries for the following …

CBSE, JEE, NEET, CUET

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

"""Write SQL queries for the following – i) Change the colour of GARMENT with code as 116 to “Orange” ii) Display count of garments available in store size wise. iii) Display all the garments available in store where name has ‘s’ in it and price more than 1200. iv) Modify structure of table to make Gcode as primary key """ i) update garment set colour='orange' where gcode=116; select * from garment; ii) select size,count(*) from garment group by size; iii)select * from garment where gname like '%s%' and price>1200; iv) alter table garment add primary key (gcode);
  • 1 answers

Akshat Krishna 2 years ago

i) update garment set colour='orange' where gcode=116; select * from garment; ii) select size,count(*) from garment group by size; iii)select * from garment where gname like '%s%' and price>1200; iv) alter table garment add primary key (gcode); this is the answer right??
http://mycbseguide.com/examin8/

Related Questions

Question no 31 case 2024
  • 0 answers
DBMS
  • 1 answers
Founder of python
  • 2 answers
What is pandas
  • 1 answers

myCBSEguide App

myCBSEguide

Trusted by 1 Crore+ Students

Test Generator

Test Generator

Create papers online. It's FREE.

CUET Mock Tests

CUET Mock Tests

75,000+ questions to practice only on myCBSEguide app

Download myCBSEguide App