PoleListCont

What you need to know about the database

List authors with more than 10 results in any given paper

Leading query segment:
SELECT

Middle query segment:

	Table column name		Alias (esp. for functions - see examples)	Display as column in output table
1		AS
2		AS		Number of results in paper
3		AS
4		AS
5		AS
6		AS
7		AS
8		AS
9		AS
10		AS

Trailing query segment:
FROM REFERENCE R, ROCKUNIT RU, PMAGRESULT PMR WHERE R.REFNO = RU.REFNO AND RU.ROCKUNITNO = PMR.ROCKUNITNO GROUP BY R.REFNO, AUTHORS HAVING COUNT(RESULTNO) > 10 ORDER BY AUTHORS