No products in the cart.

Consider the following tables GARMENT and …

CBSE, JEE, NEET, CUET

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Consider the following tables GARMENT and FABRIC. Write SQL commands for the statements (a) to (d) and give outputs for SQL queries (e) to (h). TABLE: GARMENT GCODEDESRIPTIONPRICEFCODEREADYDATE10023 PENCIL SKIRT1150F0319-DEC-0810001FORMAL SHIRT1250F0112-JAN-0810012INFORMAL SHIRT1550F0206-JUN-0810024BABY TOP750F0307-APR-0710090TULIP SKIRT850F0231-MAR-0710019EVENING GOWN850F0306-JUN-0810009INFORMAL PANT1500F0220-OCT-0810007FORMAL PANT1350F0109-MAR-0810020FROCK850F0409-SEP-0710089SLACKS 750F0320-OCT-08 TABLE: FABRIC  FCODETYPEF04POLYSTERF02COTTONF03SILKF01TERELENE (a) To display GCODE and DESCRIPTION of each GARMENT in descending order of GCODE. (b) To display the details of all the
  • 0 answers
http://mycbseguide.com/examin8/

Related Questions

What is mean by buffering in file handling?
  • 1 answers
What are called tokens
  • 2 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