SUBJECT NAME: DATABASE MANAGEMENT SYSTEM Research and Write all you know about the below questions, You are expected to Define, Discuss and show many examples to describe your answers for each question carries 20 mrks Define the following item A) GROUP BY
computer science
Description
SUBJECT NAME: DATABASE MANAGEMENT SYSTEM Research and Write all you know about the below questions, You are expected to Define, Discuss and show many examples to describe your answers for each question carries 20 mrks Define the following item A) GROUP BY B) ORDER BY C)HAVING D)UNION ALL E) INTERSECT F) GRANT Describe COMPOUND query operator. Discuss everything you know about it and give examples. Discuss and Differentiate between UNION and UNION ALL . Give sample query and show your output in a table. Discuss and Differentiate between GROUP BY and ORDER BY. Give sample query and show your output in a table.
