crosstab to find the most recent and oldest dates?
Posted on 2012-03-26
I have a table like this.
publicationT(publid, title, pubdate)
I am trying to use the crosstab to find this
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.