dkim18
asked on
crosstab to find the most recent and oldest dates?
Hi,
I have a table like this.
authort(authorid, surname,givenname)
publicationT(publid, title, pubdate)
association(pubid, authorid)
I am trying to use the crosstab to find this
row: Authorid,
column: #of publication, earliest date (of publication),oldest date(of publication)
I am having alittle trouble with find the earliest and oldest.
Can I just use FIRST and LAST?
I tried it but it errors out.
I have a table like this.
authort(authorid, surname,givenname)
publicationT(publid, title, pubdate)
association(pubid, authorid)
I am trying to use the crosstab to find this
row: Authorid,
column: #of publication, earliest date (of publication),oldest date(of publication)
I am having alittle trouble with find the earliest and oldest.
Can I just use FIRST and LAST?
I tried it but it errors out.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER