What is similar functional First(MS-Access) in Cognos??

[anumala28]

Hi,

Here i am explaining Functionality of First,

If you write a query in Access:

Select First(empno),deptno from emp
group by deptno;

it will returns output:

Only First record by Group.

Ex data:

empNo DeptNo
1 10
2 10
3 20
4 30
5 30


Out put is :

1 10
3 10
4 30


solution please

Sri