SOLVED: Assume there is a table name ITEM with below data: ITEMNO ITEMNAME ...

Assume there is a table name ITEM with below data:
ITEMNO ITEMNAME VENDORID
IT111 RULER V1111
IT112 GEOMETRY BOX V1112
IT113 NOTES V1111
IT114 COLOR BOOK V1112
IT115 CLAY BOX V1113

What will be the output of the following query?
SELECT COUNT(ITEMNO) FROM ITEM GROUP BY VENDORID;

2
2
1

5

2
2

None of the options

Correct Option - a

To get all Infosys Certified L1 Junior Mainframe Programmer Exam questions Join Group https://bit.ly/infy_premium_group

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Important Links

Privacy Policy

Refund Policy

Terms & Conditions

About Us

Contact Us

Assume there is a table name ITEM with below data: ITEMNO ITEMNAME VENDORID IT111 RULER V1111 IT112 GEOMETRY BOX V1112 IT113 NOTES V1111 IT114 COLOR BOOK V1112 IT115 CLAY BOX V1113 What will be the output of the following query? SELECT COUNT(ITEMNO) FROM ITEM GROUP BY VENDORID;

Important Links

Assume there is a table name ITEM with below data:
ITEMNO ITEMNAME VENDORID
IT111 RULER V1111
IT112 GEOMETRY BOX V1112
IT113 NOTES V1111
IT114 COLOR BOOK V1112
IT115 CLAY BOX V1113

What will be the output of the following query?
SELECT COUNT(ITEMNO) FROM ITEM GROUP BY VENDORID;