SQL Oracle query that will list faculty supervisors and their respective students . Each supervisor's students should
Fantastic news! We've Found the answer you've been seeking!
Question:
SQL Oracle query that will list faculty supervisors and their respective students. Each
supervisor's students should appear in a single row (i.e., list of values instead of
separate rows) i.e., if a faculty supervisor supervises more than one student then
all the supervised students' names should appear in a single row (next to each
other separated by a delimiter).
Present your final output in the order of faculty supervisor's id and include only those results where the number of students against a supervisor is more than 1.
Hint: May consider using Oracle's special aggregate function. Consider
searching some single-set aggregate examples.
Related Book For
Operations Management Managing Global Supply Chains
ISBN: 978-1506302935
1st edition
Authors: Ray R. Venkataraman, Jeffrey K. Pinto
Posted Date: