Function for query in Excel report option
I am trying to create some reports and I want to use some SQL functions like LAST()and FIRST(), but I got the error message "ORA-00904 "LAST" invalid identifier".
Somebody knows if why I cannot use this function? Is there a delimitation for some SQL functions in QC? [img]/images/graemlins/confused.gif[/img]
Please let me know any comment about it
Re: Function for query in Excel report option
LAST() and FIRST() are Access functions, not Oracle's.
Starting with Oracle 9i, you can use the KEEP (DENSE_RANK LAST ORDER BY ....) aggregate function (see SQL for Analysis and Reporting).