help me with AGGR function

[prasoon92]

Hi All,

I need result of this query through Set Expression in the straight  table.

select * from Employee where EmployeeName in(select  employeename from Employee where Employeename is not null group by employeename having count(contracttype)>1 )

order by EmployeeName

If anyone can help.

[pradosh_thakur]

sum( {<employeename = {"=count(contracttype)>1"}>}measure)

Try the above may be and supress null in employeename