neurotech/listagg-example.sql

Created March 26, 2013 01:50

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/neurotech/5242465.js"></script>
Save neurotech/5242465 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

listagg-example.sql

	SELECT workdept,
	LISTAGG(lastname, ', ') WITHIN GROUP(ORDER BY lastname) AS employees
	FROM emp
	GROUP BY workdept

Author

neurotech commented Mar 26, 2013

http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.sql.ref.doc%2Fdoc%2Fr0058709.html

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment